Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “figulines” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

48 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
figulines134504(None) 
figuline1256031figuline_
figurines1344501figurines
figurine1245602figurine_
fishlines15246842fishlines
aiguilles1043073aiguilles
airlines8312793ai_rlines
beguines11127213begu_ines
felines104718073f__elines
fightings17276503fightings
figurants1343973figurants
figures11239113figu__res
figuring1336283figurin_g
filings115213073fi__lings
fillies103420253fi_lli_es
fillings122910503fi_llings
finalises122911523finalises
finalizes212810743finalizes
fishline14237583fishline_
flatlines12268433flatlines
foulings12327943f_oulings
fulmines1357783f__ulmines
gumlines11238573__gumlines
guylines12236943__guylines
highlifes1942883highlifes
hiplines13310593hi_plines
inclines10313143_inclines
indulines1057763indulines
inulins7311493_inulin_s
isolines8312303_isolines
lifelines12147053lifelines
ligroines1044993ligroines
ligules82210923ligul__es
linguines1046513lingu_ines
midlines112613333mi_dlines
migraines1286933migraines
millines102718063mi_llines
nigglings12213733nigglings
picolines1339623picolines
pipelines13178353pipelines
reguline939503reguline_
ridgelines12164293ridgelines
sidelines10109683sidelines
sightlines1465753sightlines
taglines92210833tag_lines
timelines1148443timelines
vituline1147093vituline_
zibelines2045733zibelines

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.530337152.8
2DLD Change Limit148641486.40623203.4
3Display Results48480.0133692.3
 (SQL Overall)178691486.94925714.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.