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

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

232 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
disinfestations199350(None) 
disinfestation18113611disinfestation_
disinfections1954883disinfe__ctions
disinflations1756293disinf__lations
disinformations2173303disinformations
disintegrations17153633disintegrations
infestations1546623___infestations
reinfestations1793883_reinfestations
disinclinations1863584disinclinations
disinfection1855104disinfe__ction_
disinfestant1673224disinfesta___nt
disinfestants1772484disinfesta__nts
disinfesting1754434disinfes__ti_ng
disinflation1656584disinf__lation_
disinformation2063334disinformation_
disintegration16123784disintegration_
disorientations1683624disorientations
dissertations1465894dis__sertations
infestation1447044___infestation_
manifestations1981864mani_festations
misinformations2282584misinformations
reinfestation1664254_reinfestation_
contestations1547735__contestations
defenestrations1993305defen_estrations
deforestations1853965d_eforestations
delineations1346765delin_e__ations
depigmentations21102845depigmentations
desiderations1545675desi_de_rations
detestations1347585d___etestations
disaffections2253045disaffe__ctions
disaffiliations2263015disaffiliations
disinclination1763965disinclination_
disinfectant1873455disinfecta___nt
disinfectants1972375disinfecta__nts
disinfecting1954695disinfe__cti_ng
disinfests1443885disinfes__t___s
disinhibitions2062595disin_hibitions
disintegrating1763305disintegrati_ng
disintegrators1691755disintegrat_ors
disinvesting1754205disinves__ti_ng
disorientation1583775disorientation_
dispensations1655485dis__pensations
disputations15106175dis___putations
disrelations1348505dis__re_lations
dissertation1366095dis__sertation_
divinations15128415divin____ations
indentations1347885___indentations
itinerations1245685_itin_e_rations
manifestation1871995mani_festation_
misinformation2172595misinformation_
misorientations1783055misorientations
subinfeudations21121425subinfeudations
visitations1447675visi____tations
administrations18162406admin_istrations
affectations2043436___affectations
afforestations2062246_afforestations
alimentations1594996_ali_mentations
assentations1245836_as__sentations
attestations1244466___attestations
basifications20137066basi_f_ications
citifications2048546citi_f_ications
civilisations1853646civi_lis_ations
confiscations2044956__confiscations
confutations1767796__conf_utations
contestation1448666__contestation_
debilitations1647136debi__litations
decantations1547946decan___tations
decongestions1753566deconges__tions
deconsecrations2064516deconsecrations
defecations1779006d___efe_cations
defenestration18173546defen_estration_
deforestation1754306d_eforestation_
degenerations1546356degen_e_rations
degustations1444836d___egustations
deifications18410656d_ei_f_ications
delectations1547456d___electations
deliberations1645536deli_be_rations
delimitations1676636deli__mitations
delineation1247766delin_e__ation_
demonstrations1795676demon__strations
denegations1348546d__en_e_gations
denervations1657096d__en_ervations
denotations1239856d__en__otations
densifications2046986densi_f_ications
dentations11413636d_____entations
depigmentation20103046depigmentation_
desecrations1559216des___ecrations
desegregations1763566desegre_gations
desiccations1755656desi___ccations
desideration1456396desi_de_ration_
designations1456946desi___gnations
desperations1559526des__pe_rations
destinations13412666destin____ations
detestation1248366d___etestation_
devastations1645826d___evastations
dictations1389706d__i___ctations
digestions1246406d__i_ges__tions
digitalizations2686186digitalizations
digitizations2447086digi__tizations
dilatations1246416d__i__latations
diminutions1444546dimin____utions
disaffection2153206disaffe__ction_
disaffiliation2163336disaffiliation_
disaggregations1962516disaggregations
disambiguations2162156disambiguations
disapprobations2262656disapprobations
disassociations1863166disassociations
disclamations1853726dis__clamations
discolorations17104306dis_colorations
disconnections1954026disconne__ctions
disconsolations1863206disconsolations
discretions1447226dis_cre___tions
discriminations2074606discriminations
disembarkations2461506disembarkations
disfunctions1854526dis__f_unctions
disillusions1352326disillus___ions
disincentives1962866disince__ntives
disinfects1653656disinfe__ct___s
disinfest1346906disinfes__t____
disinfested1653726disinfes__t__ed
disinflationary2271366disinf__lationary
disinheriting1853476disinhe_riti_ng
disinhibition1962616disin_hibition_
disintegrates1583126disintegrat__es
disintegrative1962026disintegrati_ve
disintegrator1582056disintegrat_o_r
disinteresting1662626disinteresti_ng
disintoxication2572556disintoxication_
disinvestment1963476disinves__tment
disinvestments2063036disinvest_ments
disinvests1443766disinves__t___s
dislocations15136986dis___locations
disorientating1682706disorientati_ng
dispensation1555606dis__pensation_
dispositions1546476dis__pos_itions
disputation14116746dis___putation_
disputatious15102326dis___putatious
disquisitions2353246dis_quis_itions
disrelation1248816dis__re_lation_
dissections14198266dis____sections
disseminations1755086dis_seminations
dissentions12168046dis____sentions
dissertating1474796dis__sertati_ng
dissertational1562576dis__sertational
dissertators1352736dis__sertat_ors
dissimilations1755866dis_similations
dissimulations1754906dis_simulations
dissipations1546536dis___sipations
dissociations1656016dis__sociations
dissuasions1243526dis____suasions
distentions12178846dis__te__ntions
distillations1446946dis__tillations
distinctions1557326distin____ctions
divination14139236divin____ation_
documentations19144486d_ocumentations
dominations14611046domin____ations
dubitations1456676dubi____tations
fenestrations1695406__fen_estrations
fetations12511386_____fe_tations
forestations1546326___forestations
gasifications19116846gasi_f_ications
gestations1139776_____gestations
hesitations1448546hesi____tations
imitations1259966_imi____tations
incantations1446646___incantations
incinerations1545686incin_e_rations
incitations13310886___in_citations
incrustations15134286_i_ncrustations
indentation1248376___indentation_
indexations1946026___inde_xations
infatuations1544436___infatuations
infections15510236___infe__ctions
infiltrations1653906___infiltrations
infixations2146696___inf_ixations
inflations13310326___inf__lations
informations17127036___informations
infuriations1547446___infuriations
ingestions1197596___inges__tions
innervations1546926___innervations
insanitations13136476insan__itations
insinuations12136426insin___uations
integrations13129476___integrations
interstation12410416___interstation_
investigations1853726___investigations
invitations1449056___in_vitations
itineration1156326_itin_e_ration_
lignifications20135116lignif_ications
limitations1348186limi____tations
lineations1039546__lin_e__ations
ministrations1555446__min_istrations
miscegenations1963026miscege_nations
miscitations1647056mis___citations
miscomputations2392266miscomputations
miscreations1647066mis_cre__ations
misestimations18144426mis___estimations
misorientation1693186misorientation_
misquotations24182726mis__quotations
mistranslations17122986mistranslations
molestations1475476___molestations
nidifications1946946nidi_f_ications
noninformations2073136noninformations
orientations1246916_ori__entations
ossifications18176146ossi_f_ications
ostentations1246126_os__tentations
pigmentations1854096__pigmentations
protestations1555816__protestations
redintegrations17143256redintegrations
reforestations1754466_reforestations
regimentations1784856regi_mentations
reinfections1745326_reinfe__ctions
reinflations1546646_reinf__lations
reinnervations1753446_reinnervations
reintegrations15164786_reintegrations
restations10315846_____restations
sanitations11410846__san__itations
sedimentations1754416sedi_mentations
segmentations1655596__segmentations
sensations1059856__sen__s_ations
sequestrations23182996__sequestrations
significations20125676signif_ications
siltations1038556__si___ltations
sinuations1039416__sin___uations
subinfeudation20121466subinfeudation_
substations1348246__s__ubstations
superfetations1975066superfe_tations
superstations15208146__superstations
sustentations1354786__sustentations
vilifications2166746vili_f_ications
vinifications2177696vini_f_ications
visitation1348596visi____tation_
vivifications2486126vivi_f_ications
vociferations2153116voci_fe_rations

Search took 9 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.656272394.8
2DLD Change Limit950242327.37612882.9
3Display Results2322320.1731341.0
 (SQL Overall)1786912328.20521778.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.