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 “distributions” 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.

201 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
distributions166512(None) 
distribution1555361distribution_
distributing1654742distributi_ng
distributional1762962distributional
distributors1553032distribut_ors
redistributions18223402redistributions
attributions1453403_attributions
contributions1754743contributions
destitutions1385253dest_itutions
distinctions1557323dist_inctions
distractions1548753distr_actions
distributees15143363distribut_ees
distributes14135283distribut__es
distributive1853723distributi_ve
distributor1453553distribut_o_r
misattributions19152403misattributions
redistribution17173483redistribution_
retributions14134943_retributions
attribution1353684_attribution_
contribution1655094contribution_
descriptions1755404descri_ptions
destinations13412664dest_inations
destitution1255544dest_itution_
destructions1547254destr_uctions
detritions1148954d_etri__tions
dimerizations2548544dimerizations
diminutions1444544di__minutions
discretions1447224discr__etions
disinhibitions2062594disinhibitions
disquisitions2353244disquisitions
disrelations1348504dis_relations
disruptions14125684dis_r_uptions
dissipations1546534dis_sipations
dissolutions13144924dis_solutions
distentions12178844dist__entions
distillations1446944distillations
distinction1447324dist_inction_
distortions1246614dist__ortions
distraction1449114distr_action_
distributaries1761774distributaries
distributary1862344distribut_ary
distribute13145524distribut___e
distributed15144754distribut__ed
distributee14124924distribut__ee
distributively2362254distributively
distributivity2371584distributivity
districting1559004distri_cti_ng
divarications1955504divarications
institutions1244734inst_itutions
maldistribution201603964maldistribution_
misattribution18122484misattribution_
misdistribution20162144misdistribution_
reattributions16112424reattributions
redistributing1862674redistributi_ng
restitutions1275704rest_itutions
restrictions1449284restri_ctions
retribution13114984_retribution_
striations10312794__stri_ations
strictions1249144__stri_ctions
abstractions1645785abstr_actions
aestivations1547485aest_ivations
ascriptions1544985_ascri_ptions
attributing1453135_attributi_ng
attributional1562195_attributional
attributives1762055_attributives
attritions1066795_attri__tions
castigations1547205cast_igations
castrations13410055castr__ations
cicatrizations2794915cicatrizations
constitutions1554865const_itutions
constrictions1747785constri_ctions
contributing1754305contributi_ng
contributors16153915contribut_ors
contritions13410915contri__tions
dentitions1148855dent_i__tions
deprivations1897925d_eprivations
derivations15611495d__erivations
desalinations14410185desalinations
description1645375descri_ption_
desertions1139885deser___tions
desorptions1445995desor__ptions
destination12413845dest_ination_
destituting13155165dest_ituti_ng
destruction1446955destr_uction_
detractions14118275d_etr_actions
detrition1049135d_etri__tion_
detrusions1144215d_etr__usions
dictations1389705dict___ations
dieselizations2455915dieselizations
dietitians1142955diet_i__tians
diffractions2153275diffr_actions
digitizations2447085digitizations
dilapidations1753135dilapidations
dilutions10248585d____ilutions
dimerization2449085dimerization_
diminution1344815di__minution_
directions1379645di__r_ections
disaffections2253045disaffections
disambiguations2162155disambiguations
disapprobations2262655disapprobations
disclamations1853725disclamations
discretion1347525discr__etion_
discriminations2074605discriminations
disfunctions1854525dis_functions
disillusions1352325dis_illusions
disinfections1954885disinfections
disinflations1756295disinflations
disinhibition1962615disinhibition_
disjunctions2254075dis_junctions
dislocations15136985dis_locations
dismissions1454005dis_mi_ssions
disorientations1683625disorientations
disorienting14155655disorienti_ng
dispensations1655485dispensations
dispositions1546475dis_positions
disproportions1972285disproportions
disputations15106175dis_putations
disquisition2253335disquisition_
disrelation1248815dis_relation_
disruption13135735dis_r_uption_
dissections14198265dis__sections
disseminations1755085disseminations
dissentions12168045dis__sentions
dissertations1465895dissertations
dissimilations1755865dissimilations
dissimulations1754905dis_simulations
dissipation1447215dis_sipation_
dissociations1656015dissociations
dissolution12145025dis_solution_
distensions12146275dist__ensions
distention11158875dist__ention_
distillation1347745distillation_
distortion1146695dist__ortion_
distracting1569255distr_acti_ng
distrains10411335distr___ai_ns
districts1248935distri_ct___s
distrusting1386495distr_usti_ng
disunions1055975dis____unions
divarication1855905divarication_
divinations15128415di__vinations
elutriations1246025elutri_ations
estimations1349945_est_imations
estivations1449275_est_ivations
extrications2149055_extrications
fiberizations27136365fiberizations
filtrations1445625filtr__ations
fimbriations1943345fimbri_ations
fustigations1644765fust_igations
gastrulations1463645gastrulations
imbibitions1752385_i_mbibitions
imbrications1845685_imbrications
inhibitions1644825_i_nhibitions
inscriptions1654505inscri_ptions
instigations1348245inst_igations
institution1145295inst_itution_
instructions14137815instr_uctions
intimations13411885_int_imations
intinctions1347005_int_inctions
introductions1655135_introductions
intrusions1046335_intr__usions
intubations1346835_int_ubations
intuitions1047295_intui__tions
irrigations1246945_i_rrigations
irritations1147835_i_rritations
litigations1247335li_t_igations
lustrations1147625lustr__ations
mastications1649415mast_ications
masturbations1753425masturbations
metrications1649835_metrications
micturitions16133015micturi__tions
misattributing1961835misattributi_ng
misbuttons1452115mis___buttons
miscitations1647055mis_citations
miscreations1647065miscr_eations
misdirections1854235misdirections
misprisions1553155mispri__sions
mitigations1447625mi_t_igations
nitrations10312035ni_tr__ations
nutritions1066515_nutri__tions
obstructions16155525obstr_uctions
picturizations2764685picturizations
prostitutions1554255prost_itutions
reattribution15112525reattribution_
redistributes16122855redistribut__es
redistributive2072385redistributi_ve
restitution1175975rest_itution_
restriction1349365restri_ction_
rustications1448565rust_ications
seriations10316685__seri_ations
stictions1148355__st_i_ctions
striation9313485__stri_ation_
striction1148985__stri_ction_
stridulations1454405__stridulations
strobotrons1352055__strobotrons
substitutions1553285subst_itutions
titivations1446265ti_t_ivations
titrations1039175ti_tr__ations
tribulations1445465___tribulations
visitations1447675vis__itations
vitiations1338745vi_t_i_ations
winterizations26157505winterizations

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 Filter1786911247900.406440125.6
2DLD Change Limit1247902019.31313399.5
3Display Results2012010.1231634.1
 (SQL Overall)1786912019.84218156.0
 
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.