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
disinfestations199348(None) 
disinfestation18113601disinfestation_
disinfections1954873disinfe__ctions
disinflations1756273disinf__lations
disinformations2173293disinformations
disintegrations17153623disintegrations
infestations1546613___infestations
reinfestations1793883_reinfestations
disinclinations1863574disinclinations
disinfection1855094disinfe__ction_
disinfestant1673224disinfesta___nt
disinfestants1772484disinfesta__nts
disinfesting1754434disinfes__ti_ng
disinflation1656574disinf__lation_
disinformation2063334disinformation_
disintegration16123774disintegration_
disorientations1683614disorientations
dissertations1465884dis__sertations
infestation1447044___infestation_
manifestations1981864mani_festations
misinformations2282584misinformations
reinfestation1664254_reinfestation_
contestations1547725__contestations
defenestrations1993305defen_estrations
deforestations1853945d_eforestations
delineations1346755delin_e__ations
depigmentations21102835depigmentations
desiderations1545655desi_de_rations
detestations1347575d___etestations
disaffections2253035disaffe__ctions
disaffiliations2263005disaffiliations
disinclination1763965disinclination_
disinfectant1873455disinfecta___nt
disinfectants1972375disinfecta__nts
disinfecting1954695disinfe__cti_ng
disinfests1443885disinfes__t___s
disinhibitions2062595disin_hibitions
disintegrating1763305disintegrati_ng
disintegrators1691745disintegrat_ors
disinvesting1754205disinves__ti_ng
disorientation1583765disorientation_
dispensations1655455dis__pensations
disputations15106165dis___putations
disrelations1348485dis__re_lations
dissertation1366085dis__sertation_
divinations15128405divin____ations
indentations1347875___indentations
itinerations1245675_itin_e_rations
manifestation1871995mani_festation_
misinformation2172595misinformation_
misorientations1783045misorientations
subinfeudations21121425subinfeudations
visitations1447665visi____tations
administrations18162406admin_istrations
affectations2043436___affectations
afforestations2062226_afforestations
alimentations1594976_ali_mentations
assentations1245826_as__sentations
attestations1244466___attestations
basifications20137066basi_f_ications
citifications2048546citi_f_ications
civilisations1853646civi_lis_ations
confiscations2044956__confiscations
confutations1767786__conf_utations
contestation1448666__contestation_
debilitations1647126debi__litations
decantations1547936decan___tations
decongestions1753566deconges__tions
deconsecrations2064496deconsecrations
defecations1778996d___efe_cations
defenestration18173546defen_estration_
deforestation1754296d_eforestation_
degenerations1546336degen_e_rations
degustations1444836d___egustations
deifications18410656d_ei_f_ications
delectations1547436d___electations
deliberations1645536deli_be_rations
delimitations1676626deli__mitations
delineation1247766delin_e__ation_
demonstrations1795676demon__strations
denegations1348546d__en_e_gations
denervations1657096d__en_ervations
denotations1239836d__en__otations
densifications2046986densi_f_ications
dentations11413626d_____entations
depigmentation20103036depigmentation_
desecrations1559186des___ecrations
desegregations1763556desegre_gations
desiccations1755646desi___ccations
desideration1456386desi_de_ration_
designations1456936desi___gnations
desperations1559496des__pe_rations
destinations13412656destin____ations
detestation1248366d___etestation_
devastations1645826d___evastations
dictations1389696d__i___ctations
digestions1246406d__i_ges__tions
digitalizations2686176digitalizations
digitizations2447066digi__tizations
dilatations1246406d__i__latations
diminutions1444536dimin____utions
disaffection2153196disaffe__ction_
disaffiliation2163336disaffiliation_
disaggregations1962506disaggregations
disambiguations2162146disambiguations
disapprobations2262646disapprobations
disassociations1863156disassociations
disclamations1853716dis__clamations
discolorations17104286dis_colorations
disconnections1954006disconne__ctions
disconsolations1863196disconsolations
discretions1447216dis_cre___tions
discriminations2074596discriminations
disembarkations2461496disembarkations
disfunctions1854516dis__f_unctions
disillusions1352326disillus___ions
disincentives1962856disince__ntives
disinfects1653656disinfe__ct___s
disinfest1346906disinfes__t____
disinfested1653726disinfes__t__ed
disinflationary2271366disinf__lationary
disinheriting1853476disinhe_riti_ng
disinhibition1962616disin_hibition_
disintegrates1583126disintegrat__es
disintegrative1962026disintegrati_ve
disintegrator1582046disintegrat_o_r
disinteresting1662626disinteresti_ng
disintoxication2572556disintoxication_
disinvestment1963466disinves__tment
disinvestments2063036disinvest_ments
disinvests1443766disinves__t___s
dislocations15136976dis___locations
disorientating1682696disorientati_ng
dispensation1555586dis__pensation_
dispositions1546446dis__pos_itions
disputation14116726dis___putation_
disputatious15102316dis___putatious
disquisitions2353236dis_quis_itions
disrelation1248806dis__re_lation_
dissections14198246dis____sections
disseminations1755066dis_seminations
dissentions12168026dis____sentions
dissertating1474786dis__sertati_ng
dissertational1562566dis__sertational
dissertators1352716dis__sertat_ors
dissimilations1755856dis_similations
dissimulations1754896dis_simulations
dissipations1546526dis___sipations
dissociations1656006dis__sociations
dissuasions1243516dis____suasions
distentions12178826dis__te__ntions
distillations1446936dis__tillations
distinctions1557316distin____ctions
divination14139226divin____ation_
documentations19144476d_ocumentations
dominations14611036domin____ations
dubitations1456666dubi____tations
fenestrations1695396__fen_estrations
fetations12511386_____fe_tations
forestations1546306___forestations
gasifications19116846gasi_f_ications
gestations1139776_____gestations
hesitations1448536hesi____tations
imitations1259956_imi____tations
incantations1446636___incantations
incinerations1545666incin_e_rations
incitations13310876___in_citations
incrustations15134276_i_ncrustations
indentation1248366___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
insanitations13136466insan__itations
insinuations12136416insin___uations
integrations13129476___integrations
interstation12410416___interstation_
investigations1853726___investigations
invitations1449046___in_vitations
itineration1156326_itin_e_ration_
lignifications20135106lignif_ications
limitations1348166limi____tations
lineations1039546__lin_e__ations
ministrations1555446__min_istrations
miscegenations1963016miscege_nations
miscitations1647046mis___citations
miscomputations2392246miscomputations
miscreations1647046mis_cre__ations
misestimations18144416mis___estimations
misorientation1693176misorientation_
misquotations24182716mis__quotations
mistranslations17122976mistranslations
molestations1475466___molestations
nidifications1946936nidi_f_ications
noninformations2073126noninformations
orientations1246886_ori__entations
ossifications18176146ossi_f_ications
ostentations1246086_os__tentations
pigmentations1854076__pigmentations
protestations1555786__protestations
redintegrations17143256redintegrations
reforestations1754446_reforestations
regimentations1784846regi_mentations
reinfections1745326_reinfe__ctions
reinflations1546646_reinf__lations
reinnervations1753446_reinnervations
reintegrations15164786_reintegrations
restations10315836_____restations
sanitations11410836__san__itations
sedimentations1754406sedi_mentations
segmentations1655586__segmentations
sensations1059846__sen__s_ations
sequestrations23182986__sequestrations
significations20125676signif_ications
siltations1038546__si___ltations
sinuations1039396__sin___uations
subinfeudation20121466subinfeudation_
substations1348226__s__ubstations
superfetations1975056superfe_tations
superstations15208146__superstations
sustentations1354746__sustentations
vilifications2166746vili_f_ications
vinifications2177696vini_f_ications
visitation1348586visi____tation_
vivifications2486126vivi_f_ications
vociferations2153096voci_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.1231452772.4
2DLD Change Limit950242328.09311741.5
3Display Results2322320.1731341.0
 (SQL Overall)1786912328.38921300.6
 
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.