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

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

129 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
necessitations1612279(None) 
necessitation15123091necessitation_
necessitarians1671632necessitarians
necessitating1662372necessitati_ng
necessitarian1571763necessitarian_
necessitates1452443necessitat__es
cessations1256474__cess__ations
decapitations1847664dec_apitations
decrepitations1984344decrepitations
decussations1543674decuss__ations
detestations1347584dete_s_tations
encrustations15123084encrus_tations
exercitations2254564_exercitations
hesitations1448544__he_sitations
necessitate1352534necessitat___e
necessitated1552254necessitat__ed
necessities1354574necessi__ti_es
necessitous1351564necessi__t_ous
recitations13314204rec___itations
resuscitations1673784resuscitations
acceptations1864505acce__ptations
accreditations19122625accreditations
aestivations1547485__aestivations
assassinations13102045assassinations
attestations1244465atte_s_tations
capitations1549855__c_apitations
cassations1276875__cass__ations
castigations1547205__castigations
cavitations1647845__c_avitations
cementations1659015__cementations
cessation1176855__cess__ation_
citations11312505__c___itations
cogitations1448905__c_ogitations
crepitations1647475__crepitations
cuspidations1743345__cuspidations
debilitations1647135de_bilitations
decantations1547945dec__antations
decapitation1748685dec_apitation_
decelerations1646425dece_lerations
decerebrations1993745decerebrations
decimations16410165dec___imations
declinations15410225dec__linations
decortications1966775decortications
decrepitation1884805decrepitation_
decussation1444305decuss__ation_
degustations1444835de_gus_tations
delectations1547455dele__ctations
delimitations1676635de_limitations
derealizations24910815derealizations
destinations13412665__destinations
destitutions1385255__destitutions
determinations1766895determinations
detestation1248365dete_s_tation_
devastations1645825de_vas_tations
dissipations1546535__dissipations
domestications19143995domestications
elicitations1446805_e_licitations
encapsulations1851995encapsulations
encrustation14103395encrus_tation_
energizations2356185_energizations
equitations2047445___equitations
estimations1349945___estimations
estivations1449275___estivations
eternizations2258075_eternizations
excitations2049005___excitations
excogitations2353835_excogitations
exercitation2155385_exercitation_
exploitations2254215_exploitations
facilitations1845765fac_ilitations
felicitations1874585fe_licitations
fenestrations1695405fene_strations
forestations1546325fore_s_tations
gestations1139775__ge_s_tations
hebetations1656465hebe___tations
hesitation1349635__he_sitation_
incitations13310885inc___itations
incrustations15134285incrus_tations
infestations1546625infe_s_tations
investigations1853725investigations
jactitations2145015jac__titations
levitations1448295__le_vitations
mechanizations3055815mechanizations
meditations1449335__me_ditations
mercerizations2756105merce_rizations
miscitations1647055__miscitations
misestimations18144425misestimations
molestations1475475mole_s_tations
nebulizations2446675ne_bulizations
necessaries1353095necess__ari_es
negotiations1345155ne_goti_ations
nictations1278315nic____tations
novelizations2556365nove_lizations
overestimations20124605overestimations
passivations1764435__passivations
pectinations1649255pec__tinations
peregrinations17114685peregrinations
perspirations1786175pe_rspirations
precipitations2085395prec_ipitations
predestinations1865005predestinations
premeditations1955015preme_ditations
presentations1548135_presentations
racemizations2665475race_mizations
recantations1448875rec__antations
recessions1248935recess____ions
recitation12315945rec___itation_
recombinations2095595recombinations
recompilations2054955recompilations
recomputations20104105recomputations
reconstitutions1763275reconstitutions
recriminations1856725recriminations
rectifications2148915rectifications
rededications1746125rede_dications
reescalations1573785re_escalations
regurgitations16133145regurgitations
remediations1548275reme_di_ations
renegotiations15113375renegotiations
representations17153895representations
reregistrations1672825reregistrations
respirations14410305__respirations
restations10315845__re_s_tations
restitutions1275705__restitutions
resuscitation1554295resuscitation_
revegetations17114715reve_getations
secessions1246465secess____ions
sexploitations2352715sexploitations
superstations15208145supers_tations
teleportations1651825teleportations
vegetations1547325vege___tations
visitations1447675___visitations

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 Filter178691950240.356501941.0
2DLD Change Limit950241295.92316043.2
3Display Results1291290.0931387.1
 (SQL Overall)1786911296.37228043.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.