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 “aigrettes” 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
aigrettes104639(None) 
aigrette946831aigrette_
aigrets82810532aigre_t_s
cigarettes1343332cigarettes
vignettes1344672vignettes
accretes1238113accre_tes
aggregates1344123aggregates
aggresses1146143aggresses
agrees74915323a_gre__es
aiglets84012913aigle_t_s
aigret73720023aigre_t__
airdates939723ai_rdates
amarettos1193943amarettos
amorettos1184663amorettos
anisettes946673anisettes
aretes64425353a__re_tes
ariettes8411353a_riettes
baguettes12115393baguettes
barrettes1149063barrettes
bimbettes1544153bimbettes
birettas1046513bi_rettas
birrettas1143503birrettas
burettes1048943_burettes
cigarette1243783cigarette_
curettes1039313_curettes
digresses1137863digresses
dinettes9310193di_nettes
diskettes1446573diskettes
languettes1144643languettes
lazarettes1953013lazarettes
librettos1153593librettos
majorettes1943553majorettes
migrates111112853migr_ates
paillettes1244653paillettes
pipettes1237563pi_pettes
regretted1137233regretted
regretter1045973regretter
regretters1144093regretters
rillettes946533rillettes
syrettes1136963_syrettes
tigresses1046403tigresses
umbrettes1344143umbrettes
videttes1266333vi_dettes
vignette1245043vignette_
vignetted1443493vignetted
vignetter1343323vignetter
vignetters1442453vignetters
vinaigrettes166653vinaigrettes

Search took 8 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.1731032896.0
2DLD Change Limit148641487.34320242.5
3Display Results48480.0301600.0
 (SQL Overall)178691487.54623680.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.