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 “recitation” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
recitation1231594(None) 
recitations13314201recitations
citation10314362__citation
crepitation1548392crepitation
decimation15411622decimation
excitation19410172excitation
hesitation1349632hesitation
incitation12312222incitation
levitation1349442levitation
meditation13410742meditation
recantation1349862recantation
recitative1548182recitative
recitativi1553742recitativi
recitativo1555822recitativo
recitativos1652172recitativos
recreation12413612recreation
refutation1349912refutation
reputation12411882reputation
restation9316912re_station
agitation10311223_agitation
brecciation1744773brecciation
capitation14311363capitation
cavitation1549133cavitation
citations11312503__citations
cogitation13410083cogitation
crepitations1647473crepitations
decantation1448943decantation
decapitation1748683decapitation
decimations16410163decimations
declination14411873declination
decoration13314423decoration
dedication14311963dedication
denotation11311083denotation
dentation10315243de_ntation
depilation13312033depilation
deputation1339393deputation
derivation14712783derivation
deviation13312393devi_ation
dictation12810563dic_tation
dubitation1377333dubitation
elicitation1347533elicitation
epilation11312963_epilation
equitation1948343equitation
eructation1248333eructation
excitations2049003excitations
exercitation2155383exercitation
felicitation1745103felicitation
fetation11613143fe__tation
gemination131410653gemination
gestation10310663ge_station
gravitation1545513gravitation
habitation1547913habitation
hebetation1557093hebetation
hesitations1448543hesitations
imitation11510853_imitation
incitations13310883incitations
invitation13410023invitation
irritation1048973irritation
jactation1838143jac_tation
jactitation2045623jactitation
lactation11310813lac_tation
levigation1447023levigation
levitations1448293levitations
limitation1249153limitation
mediation12312293medi_ation
medication15411173medication
meditations1449333meditations
mentation11313983me_ntation
miscitation1547773miscitation
nictation1189273nic_tation
pectination15410333pectination
peculation14311993peculation
peltation11312963pe_ltation
precipitation1966223precipitation
predication16412433predication
prelibation15128663prelibation
radiation10313393radi_ation
reactivation17176953reactivation
realization20417223realization
reanimation1359633reanimation
recantations1448873recantations
recaution1148093rec_aution
reception13410323rec_eption
recision10310273reci__sion
recitalist1248983recitalist
recitatives1645193recitatives
reclamation1546353reclamation
recordation1449263recordation
recreations13412253recreations
reflation12412333re_flation
refutations1448673refutations
registration1347533registration
regulation11312053regulation
reification16412903reification
reiteration11412163re_iteration
relation82619773re__lation
relaxation1746453relaxation
relegation11610023relegation
reliction11310693reli_ction
relocation12312113relocation
reluctation1347963reluctation
remigration14228913remigration
renovation1358783renovation
reoxidation1946653reoxidation
reparation12612723reparation
repetition1278233repetition
replication15712013replication
reputations13410733reputations
resignation1247473resignation
respiration13511193respiration
restations10315843re_stations
restitution1175973restitution
resuscitation1554293resuscitation
revelation13410923revelation
revocation15410813revocation
rotation81615453r__otation
ruination9311273r_uination
rumination12410833rumination
sanitation10412043sanitation
seriation9318063seri_ation
speciation1449393speci_ation
temptation1446383temptation
trepidation1445493trepidation
vegetation1448213vegetation
visitation1348593visitation

Search took 7 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.186960704.3
2DLD Change Limit1406031256.42321890.5
3Display Results1251250.0602083.3
 (SQL Overall)1786911256.66926794.3
 
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.