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

65 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
resituated114732(None) 
resituate948611resituate_
resituates1047751resituates
hesitated1377782hesit_ated
resinated10413282resi_nated
restated93120182res_t_ated
restituted1156532restitu_ted
situated938032__situated
aestivated14106293aestivated
crepitated1584743crepit_ated
denitrated1298033denitrated
desiccated1644993desiccated
designated1345933designated
destituted1255253destitu_ted
estated83715573_es_t_ated
estimated12109443_estimated
estivated13108323_estivated
festinated1447533festinated
gestated102910573ges_t_ated
habituated1643053habituated
hesitate1169973hesit_ate_
hesitater1276923hesit_ater
hesitates1269793hesit_ates
insinuated1144813insinuated
levitated1346413levit_ated
meditated1348083medit_ated
redictated1447483redictated
reestimated1445953reestimated
refitted12309413refit__ted
reinitiated1245203reinitiated
reiterated11410153re_iterated
remigrated1447493remigrated
remitted113312073remit__ted
resaluted1046473resalu_ted
reseated93220263res__eated
resifted12310153resi__fted
resighted1436523resi_ghted
resinate8316773resi_nate_
resinates9314763resi_nates
resisted9312693resi__sted
resited85122423resi___ted
resituating1247543resituating
reslated93517523res__lated
resonated10510613res_onated
restaged103011863res_t_aged
restarted10410053res_tarted
restate73824883res_t_ate_
restates83423433res_t_ates
restimulated1564903restimulated
restitute947753restitu_te_
restitutes1057833restitu_tes
restudied11104853res_tudied
restuffed1663333res_tuffed
resulted939713res__ulted
reticulated14127783reticulated
revaluated14306363revaluated
revibrated1645443revibrated
revictualed1751483revictualed
reviolated1446253reviolated
rusticated1346993rusticated
sinuated938413__sinuated
situate7410783__situate_
situates8310373__situates
vesicated15117653vesi_cated
vesiculated1745553vesiculated

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 Filter1786911406030.420425454.8
2DLD Change Limit140603656.72020923.1
3Display Results65650.0302166.7
 (SQL Overall)178691657.17024922.0
 
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.