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

63 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
resituate94861(None) 
resituated1147321resituated
resituates1047751resituates
hesitate1169972hesit_ate
resinate8316772resi_nate
restate73824872res_t_ate
restitute947742restitu_te
situate7410772__situate
aestivate12127663aestivate
crepitate1385953crepit_ate
deciduate1345063deciduate
denitrate10810533denitrate
desiccate1445923desiccate
designate1147113designate
destitute1046873destitu_te
estate64719763_es_t_ate
estimate10912003_estimate
estivate111010003_estivate
festinate1249473festinate
gestate83614073ges_t_ate
habituate1443923habituate
hesitated1377783hesit_ated
hesitater1276923hesit_ater
hesitates1269793hesit_ates
insinuate945963insinuate
levitate1137933levit_ate
meditate11310623medit_ate
redictate1249063redictate
reestimate1246513reestimate
reinitiate1046043reinitiate
reiterate9412923re_iterate
remigrate1249223remigrate
resalute857413resalu_te
residua8286623residua__
residual9245443residua_l
residuals10223803residuals
residuary1342653residuary
residue8689863residu__e
resinated10413283resi_nated
resinates9314763resi_nates
resite64128453resi___te
resituating1247543resituating
reslate73520593res__late
resolute868513resolu_te
resonate8513513res_onate
restage83316183res_t_age
restated93120173res_t_ated
restates83423413res_t_ates
restimulate1365843restimulate
restituted1156523restitu_ted
restitutes1057823restitu_tes
reticulate12219783reticulate
revaluate12277103revaluate
revibrate1446373revibrate
reviolate1248123reviolate
rostrate8313833ros_trate
rusticate1149033rusticate
sinuate7412153__sinuate
situated938023__situated
situates8310363__situates
testate73916233tes_t_ate
vesicate131210053vesi_cate
vesiculate1547223vesiculate

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641638.83016833.6
3Display Results63630.0134846.2
 (SQL Overall)178691638.99919856.8
 
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.