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

68 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
hesitant114908(None) 
habitant1348672habitant
hesitance1445552hesitance
hesitancy1743542hesitancy
hesitantly1653002hesitantly
hesitate1169972hesitate
resistant948612resistant
vesicant1347502vesicant
visitant1147362visitant
assistant944963assistant
crepitant1346313crepitant
debutant1146183debutant
defiant11311923defi_ant
descant104315593des_cant
desiccant1444193desiccant
desinent9312963desinent
deviant11311313devi_ant
distant83519953dis_tant
equitant1746923equitant
excitant1777353excitant
extant132714753_e_xtant
gestalt8411173ges_talt
habitan1236903habitan_
habitans1346623habitans
habitants1445123habitants
habitat12411053habita_t
heisting123411043heisting
heliast10312073heli_ast
heptane1238363he_ptane
heritage1246533heritage
hesitances1545543hesitances
hesitated1377783hesitated
hesitater1276923hesitater
hesitates1269793hesitates
hesitating1448003hesitating
hesitator1286023hesitator
hessian1035853hessian_
hessians1145053hessians
incitant10810083incitant
instant7815353ins_tant
irritant847693irritant
jessant1438443jes_sant
mediant103516703medi_ant
medicant13910833medicant
mesian84315503mesi_an_
militant10411403militant
oscitant1046903oscitant
penitent10413503penitent
reactant10311433reactant
reliant7319243reli_ant
renitent8315333renitent
reptant92817073re_ptant
resident9313753resident
resistants1045523resistants
resiting93521123resiting
resonant8410813resonant
restart7320033res_tart
resultant946443resultant
retirant8313593retirant
seitan62613233se_itan_
seitans73312303se_itans
sextant142911963se_xtant
sheitan1036573she_itan_
sheitans1155603she_itans
vegetant1246963vegetant
vesicants1444753vesicants
visitants1244763visitants
volitant1147863volitant

Search took 9 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.423422437.4
2DLD Change Limit146162687.98318309.2
3Display Results68680.0164250.0
 (SQL Overall)178691688.42221217.2
 
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.