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 “recitations” 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
recitations1331420(None) 
recitation12315941recitation_
citations11312502__citations
crepitations1647472crepitations
decimations16410162decimations
excitations2049002excitations
hesitations1448542hesitations
incitations13310882incitations
levitations1448292levitations
meditations1449332meditations
recantations1448872recantations
recitatives1645192recitatives
recitativos1652172recitativos
recreations13412252recreations
refutations1448672refutations
reputations13410732reputations
restations10315842re_stations
agitations11310063_agitations
brecciations1844283brecciations
capitations1549853capitations
cavitations1647843cavitations
citation10314363__citation_
cogitations1448903cogitations
crepitation1548393crepitation_
decantations1547943decantations
decapitations1847663decapitations
decimation15411623decimation_
declinations15410223declinations
decorations14312883decorations
dedications15310873dedications
denotations1239853denotations
dentations11413633de_ntations
depilations14310903depilations
deputations1448343deputations
derivations15611493derivations
deviations14311163devi_ations
dictations1389703dic_tations
dubitations1456673dubitations
elicitations1446803elicitations
epilations12311713_epilations
equitations2047443equitations
eructations1347233eructations
excitation19410173excitation_
exercitations2254563exercitations
felicitations1874583felicitations
fetations12511383fe__tations
geminations14139253geminations
gestations1139773ge_stations
gravitations1644763gravitations
habitations1646883habitations
hebetations1656463hebetations
hesitation1349633hesitation_
imitations1259963_imitations
incitation12312223incitation_
invitations1449053invitations
irritations1147833irritations
jactations1936893jac_tations
jactitations2145013jactitations
lactations1239423lac_tations
levigations1546213levigations
levitation1349443levitation_
limitations1348183limitations
mediations13310983medi_ations
medications1649933medications
meditation13410743meditation_
mentations12312583me_ntations
miscitations1647053miscitations
nictations1278313nic_tations
pectinations1649253pectinations
peculations15310283peculations
peltations12311553pe_ltations
precipitations2085393precipitations
predications17411183predications
prelibations16127623prelibations
radiations11311923radi_ations
reactivations18176143reactivations
realizations21415533realizations
reanimations1468783reanimations
recantation1349863recantation_
recautions1247813rec_autions
receptions1449743rec_eptions
recisions1139913reci__sions
recitalists1346503recitalists
recitative1548183recitati_ve
recitativi1553743recitati_vi
recitativo1555823recitati_vo
reclamations1645713reclamations
recordations1548643recordations
recreation12413613recreation_
reflations13311233re_flations
refutation1349913refutation_
registrations1446893registrations
regulations12310713regulations
reifications17411823reifications
reiterations12410873re_iterations
relations92418333re__lations
relaxations1845643relaxations
relegations1248973relegations
relictions12310023reli_ctions
relocations13311143relocations
reluctations1446753reluctations
remigrations15227793remigrations
renovations1448423renovations
reoxidations2046043reoxidations
reparations13611663reparations
repetitions1378023repetitions
replications16811053replications
reputation12411883reputation_
resignations1346883resignations
respirations14410303respirations
restation9316913re_station_
restitutions1275703restitutions
resuscitations1673783resuscitations
revelations14410303revelations
revocations16410313revocations
rotations91613843r__otations
ruinations1039603r_uinations
ruminations1349393ruminations
sanitations11410843sanitations
seriations10316683seri_ations
speciations1548483speci_ations
temptations1545413temptations
trepidations1554933trepidations
vegetations1547323vegetations
visitations1447673visitations

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 Filter1786911216330.390458182.1
2DLD Change Limit1216331255.62621619.8
3Display Results1251250.0761644.7
 (SQL Overall)1786911256.09229332.1
 
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.