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

(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
disaffiliations2263011disaffiliations_
disaffiliation2163332disaffiliation__
disaffiliating2262273disaffiliati_n_g
affiliations1844184___affiliations_
disaffiliates2062524disaffiliat__es_
affiliation1744855___affiliation__
disaffections2253045disaff__ections_
disaffiliate1962635disaffiliat____e
disaffiliated2172435disaffiliat___ed
disambiguations2162155disambiguations_
disassociations1863165disassociations_
disinflations1756295disinf_l_ations_
dissimilations1755865dissimil_ations_
distillations1446945dis__tillations_
affiliating1844166___affiliati_n_g
affirmations2053236___affirmations_
affixations2443856___affi_xations_
afflictions1943406___aff_lictions_
defoliations1647596d___efoliations_
desalinations14410186desa_li_nations_
desalinizations2555396desa_linizations_
despoliations1646396des__poliations_
dilapidations1753136dila_pi_dations_
disabilities15411146disa_bili_ti_es_
disaffection2153206disaff__ection__
disaggregations1962516disaggregations_
disambiguation2062226disambiguation__
disapprobations2262656disapprobations_
disassociation1763286disassociation__
discriminations2074606dis_criminations_
disinclinations1863586disinclinations_
disinfestations1993506disinfestations_
disinflation1656586disinf_l_ation__
disinformations2173306disinformations_
disinhibitions2062596disinhibi_tions_
disquisitions2353246dis_quisi_tions_
disrelations1348506dis__rel_ations_
disseminations1755086dissemi_nations_
dissimilation1656526dissimil_ation__
dissimulations1754906dissimul_ations_
dissipations1546536dis__si_pations_
dissociations1656016dis__sociations_
distillation1347736dis__tillation__
divarications1955506diva_ri_cations_
domiciliations1992536d_omiciliations_
filiations13119096_____filiations_
insufflations19112626insuff_l_ations_
misapplications2363076misapplications_
misutilizations26145156mis_utilizations_
officiations2053506___officiations_
reaffirmations2251976_reaffirmations_
suffixations2562546__suffi_xations_
affectations2043437___affectations_
affiliates1644897___affiliat__es_
affirmation1953687___affirmation__
affixation2344397___affi_xation__
affliction1843547___aff_liction__
assassinations13102047assassi_nations_
assimilations1555207_assimil_ations_
basifications20137067bas_ifi_cations_
beneficiations21182217_beneficiations_
cantillations1545737__cantillations_
cicatrizations2794917cicatri_zations_
ciliations121111007_____ciliations_
citifications2048547ci_tifi_cations_
civilisations1853647ci___vilisations_
civilizations2747277ci___vilizations_
conciliations1747207__conciliations_
dandifications2145437dandifi_cations_
deactivations19175067d_eacti_vations_
dealations11311377d_ea___l_ations_
deaminations151010137d_ea_mi_nations_
debilitations1647137d___ebilitations_
decapitations1847667deca_pi_tations_
defalcations1845197d___efalcations_
defibrillations2161697defibrillations_
definitions1545607d___efini_tions_
deflations1439717d___ef_l_ations_
defoliation1548317d___efoliation__
deifications18410657d__eifi_cations_
delaminations1647947dela_mi_nations_
demobilizations2955497d_emobilizations_
denazifications30164087denazifications_
densifications2046987densifi_cations_
depilations14310907d___epil_ations_
deracinations1647837dera_ci_nations_
desacralization2754177desacralization__
desalination13411137desa_li_nation__
desalinization2455617desa_linization__
desiccations1755657des___iccations_
designations1456947des___ignations_
desolations12310597des___ol_ations_
despoliation1546717des__poliation__
destabilization2763337destabilization__
destinations13412667des__ti_nations_
devaluations1646357deva___luations_
diazotizations2353687di_azotizations_
dieselizations2455917dieseli_zations_
diffractions2153277di__ff_ractions_
digitalizations2686187digitalizations_
digitizations2447087di_giti_zations_
dilapidation1653367dila_pi_dation__
dilatations1246417dila____tations_
dilations102614457d_____il_ations_
dimerizations2548547di_meri_zations_
disaffecting2252937disaff__ecti_n_g
disaffirmance2471527disaffirma___nce
disaffirmances25101537disaffirma_nces_
disaffirming2252077disaff__irmi_n_g
disaggregation1862697disaggregation__
disambiguating2171897disambiguati_n_g
disapprobation2162667disapprobation__
disarticulation1863577disarticulation__
disassociating1862477disassociati_n_g
disclamations1853727dis__clamations_
discolorations17104307dis_colorations_
disconsolations1863207disconsolations_
discrimination1955357dis_crimination__
disembarkations2461507disembarkations_
disfunctions1854527dis__f_unctions_
disillusions1352327dis___illusions_
disinclination1763967disinclination__
disinfections1954887disinf__ections_
disinfestation18113617disinfestation__
disinflationary2271367disinf_l_ationary
disinformation2063337disinformation__
disinhibition1962617disinhibi_tion__
disintegrations17153637disintegrations_
dislocations15136987dis___locations_
disorientations1683627disorientations_
dispensations1655487dis__pensations_
dispositions1546477dis__posi_tions_
disputations15106177dis___putations_
disquisition2253337dis_quisi_tion__
disrelation1248817dis__rel_ation__
dissemination1655797dissemi_nation__
dissertations1465897dis__sertations_
dissimilating1754417dissimil_ati_n_g
dissimulation1655377dissimul_ation__
dissipation1447217dis__si_pation__
dissociation1556647dis__sociation__
dissolutions13144927dis__sol_utions_
distinctions1557327dis__ti_nctions_
distributions1665127dis_tri_butions_
disutilities1355157dis_utili_ti_es_
divagations16103837diva____gations_
divarication1855907diva_ri_cation__
divinations15128417di___vi_nations_
domiciliation18102507d_omiciliation__
edifications1848697edi___fi_cations_
exfoliations2244787___exfoliations_
facilitations1845767__fa_cilitations_
fibrillations1853107fi__brillations_
filiation121110247_____filiation__
finalizations2549257fina_li_zations_
foliations1399947_____foliations_
fossilizations2654687fos__silizations_
gasifications19116847gas_ifi_cations_
habilitations1884867__ha_bilitations_
humiliations1784557___humiliations_
idealizations2379457idea_li_zations_
imaginations1546347_ima_gi_nations_
immobilizations30183297_immobilizations_
inactivations1854247_inacti_vations_
infiltrations1653907_i__nfiltrations_
infixations2146697_i__nfi_xations_
inflations13310327_i__nf_l_ations_
inflictions1645447_i__nf_lictions_
infuriations1547447_i__nfuriations_
initiations11410727_i___nitiations_
insanitations13136477insa_ni_tations_
instillations1344927_i_nstillations_
insufflation18112877insuff_l_ation__
invigilations1764487_invigil_ations_
isolations10310697_is___ol_ations_
italicizations2553807_ita_licizations_
justifications2645557justifi_cations_
laciniations1445917__la_ciniations_
lignifications20135117lignifi_cations_
lithifications22134797lithifi_cations_
lixiviations2252767li___xiviations_
misallocations1853097misa_llocations_
misapplication2263347misapplication__
miscalculations2172837miscalcul_ations_
miscitations1647057mis__ci_tations_
misestimations18144427misesti_mations_
misevaluations19133457mis_evaluations_
misinformations2282587misinformations_
misutilization25155487mis_utilization__
mystifications2445647mystifi_cations_
nasalizations2248707nasa_li_zations_
nidifications1946947ni_difi_cations_
nitrifications1986637nitrifi_cations_
officiation1943837___officiation__
oscillations1445117_os__cillations_
ossifications18176147_ossifi_cations_
palliations1347727__pa__lliations_
pixilations2045337pi___xil_ations_
reaffirmation2152067_reaffirmation__
reconciliations1953747reconciliations_
redistillations1672917redis__tillations_
rehabilitations2053037reha_bilitations_
retaliations12511407reta___liations_
sacculations1646667__saccul_ations_
salinizations2258427__sa_linizations_
salivations1448737__sa_li_vations_
saltations10310627__sa___ltations_
salvations1338137__sa___lvations_
sanitations11410847__sa_ni_tations_
sanitizations2248557__sa_nitizations_
satiations10312117__sa___tiations_
sibilations13127937__s_ibil_ations_
significations20125677signifi_cations_
siltations1038557__s___iltations_
spoliations1347697__s__poliations_
stabilizations2565607__stabilizations_
stagflations1652867_stagf_l_ations_
sterilizations2357987__sterilizations_
subtilizations2556067__subtilizations_
suffixation2452867__suffi_xation__
suffocations2053097__suff_ocations_
titillations1244447ti___tillations_
vacillations1744877__va_cillations_
vasodilations1752987vas_odil_ations_
vilifications2166747vi_lifi_cations_
vinifications2177697vi_nifi_cations_
visitations1447677vis___i_tations_
visualizations2657397visuali_zations_
vitalizations25410327vita_li_zations_
vitrifications2275967vitrifi_cations_
vivifications2486127vi_vifi_cations_
volatilizations2794337vola_tilizations_

Search took 10 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.360496363.9
2DLD Change Limit950242328.95310613.6
3Display Results2322320.1901221.1
 (SQL Overall)1786912329.50318803.6
 
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.