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 “stagnate” 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.

81 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
stagnate94724(None) 
stagnated1145141stagnated
stagnates1046731stagnates
agnate73314872__agnate
magnate10512702_magnate
stagnance1243502stagnance
stagnant946892stagnant
staminate1187982staminate
stannite847582stannite
tannate71813522_tannate
adnate72913483__adnate
agate66525143__ag_ate
agnates82813183__agnates
catenate10312833catenate
cognate10312193_cognate
cyanate12259703cya_nate
emanate9312473ema_nate
evaginate1376483evaginate
khanate1437073kha_nate
lanate6421263_la_nate
magnates11511603_magnates
paginate114012443_paginate
patinate103016313patinate
planate9314573pla_nate
saccate111311763s_accate
satiate7315403s_atiate
saturate8312813saturate
savate9313783s_a_vate
seatmate1048573seatmate
selenate81712523selenate
senate63725143s__enate
serenate81914873serenate
shogunate1342853shogunate
sigmate10710123s_igmate
signage937773s_ignage
slainte738543slain_te
spinate93114813s_pinate
staccati1244673staccati
staccato1244063staccato
stacte82113913sta__cte
stage65330193stag___e
stageable1246343stageable
staggard1144513staggard
staggart1046643staggart
staggarts1143753staggarts
staggie9138463stag_gie
stagnances1343343stagnances
stagnancy1552553stagnancy
stagnantly1452293stagnantly
stagnating1254973stagnating
stagnation1145543stagnation
stainable1138093stainable
stalemate1146643stalemate
stance84316913sta_n_ce
standee83514513sta_ndee
stane55933003sta_n__e
stanine73417073sta_nine
stannary1144613stannary
stannites947013stannites
stargaze1844553stargaze
starnose8136683starnose
statant7313123statant_
state56237333st___ate
statute7419323sta_tute
stearate839713stearate
stellate8310503stellate
sternite8310543sternite
stibnite1044073stibnite
stigmata1144663stigmata
stolonate944823stolonate
stomate9313123st_omate
striate74218953st_riate
stylate10179773st_ylate
sultanate946053sulta_nate
supinate10310313supinate
tannage8209583_tannage
tannates81911953_tannates
ternate7415483_ternate
titanate897163tita_nate
togate74515683_tog_ate
vaginate123911083_vaginate

Search took 10 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 Filter1786911461620.190940478.9
2DLD Change Limit146162819.31315694.4
3Display Results81810.0601350.0
 (SQL Overall)178691819.56318685.7
 
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.