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

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

242 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
deflorations164606(None) 
defloration1547261defloration_
declarations1546802declarations
decorations14312882de_corations
deflagrations1883022deflagrations
deflations1439712defl__ations
defoliations1647592defoliations
deformations1846842def_ormations
colorations13911893_colorations
deaerations12311673de_aerations
dealations11311373deal__ations
decelerations1646423decelerations
declamations1745303declamations
declaration1447833declaration_
declinations15410223declinations
decollations1547363decollations
decoration13314423de_coration_
defalcations1845193defalcations
defamations1745893def_amations
defecations1779003def_ecations
deflagration1773473deflagration_
deflation13310653defl__ation_
deflections17187323defl_ections
defoliation1548313defoliation_
deformation1747663def_ormation_
dehydrations2043403dehydrations
delations102616593de_l__ations
delegations1348033de_legations
denigrations1447353denigrations
denotations1239853de_notations
deportations1548463de_portations
derogations1349393de_rogations
desecrations1559213desecrations
desolations12310593de_solations
desorptions1445993de_sorptions
desperations1559523desperations
detonations1239373de_tonations
deuterations1348083deuterations
dislocations15136983dislocations
explorations2185613explorations
floriations1476913__floriations
flotations1366873__flotations
meliorations1466753meliorations
perforations1747873perforations
perorations13314063pe_rorations
reflations13311233refl__ations
reformations1747603ref_ormations
relocations13311143re_locations
restorations12410953restorations
adorations11310234__adorations
aerations9317904ae___rations
allocations1347774_allocations
ameliorations1563194ameliorations
bilocations1545294_bilocations
celebrations1645744celebrations
cerebrations1646964cerebrations
collocations1646404collocations
coloration12913184_coloration_
corporations16129484corporations
deaeration11313014de_aeration_
dealation10313004deal__ation_
deaminations151010134deaminations
debarkations1943654debarkations
debilitations1647134debilitations
decantations1547944decantations
deceleration1547174deceleration_
dechlorinations2153114dechlorinations
decimations16410164de_cimations
declamation1646104declamation_
declination14411874declination_
decoctions1547144de_co_ctions
decollation1448194decollation_
decolorizations27136104decolorizations
decorating14312074de_corati_ng
decorators1347874de_corat_ors
decussations1543674decussations
dedications15310874de_dications
defalcation1746224defalcation_
defamation1646844def_amation_
defecation1679804def_ecation_
defections161510204def__ections
defibrinations2053414defibrinations
definitions1545604def_initions
deflagrating1852664deflagrati_ng
deflating142610714defl__ati_ng
deflators13348154defl__at_ors
deflection16147734defl_ection_
deflexions2142564defl__exions
defoliating1645824defoliati_ng
defoliators1543724defoliat_ors
deforestations1853964def_orestations
deformational19122974def_ormational
degenerations1546354degenerations
deglaciations1753914deglaciations
deglutitions1452154deglutitions
degradations1544554degradations
degustations1444834degustations
dehydration1954064dehydration_
deifications18410654deifications
delation92318084de_l__ation_
delectations1547454delectations
delegation1238884de_legation_
deletions102610934de_l__etions
deliberations1645534deliberations
delineations1346764delineations
demarcations1746124demarcations
demolitions1446524de_molitions
demotions1258444de_mo__tions
denaturations1444954denaturations
denegations1348544de_negations
denervations1657094denervations
denigration1348464denigration_
denotation11311084de_notation_
dentations11413634de__ntations
denudations1346344de_nudations
deodorizations2556324deodorizations
deoxidations2145244deoxidations
depilations14310904de_pilations
depletions1355744depl__etions
deportation1449304de_portation_
depositions14117684de_positions
depravations1885374depravations
deprecations1748564deprecations
depredations1646734depredations
deprivations1897924deprivations
deputations1448344de_putations
derivations15611494de_rivations
derogation12410394de_rogation_
desalinations14410184desalinations
desecration14410074desecration_
desertions1139884de_ser_tions
desiccations1755654desiccations
desiderations1545674desiderations
designations1456944designations
desolation11311404de_solation_
desorption1346224de_sorption_
desperation14510114desperation_
despoliations1646394despoliations
destinations13412664destinations
deteriorations15164694deteriorations
detestations1347584detestations
detonation11310944de_tonation_
detractions14118274de__tractions
detritions1148954de__tritions
deuteration1249104deuteration_
devaluations1646354devaluations
devastations1645824devastations
deviations14311164de__viations
devolutions15106264de_volutions
devotions1356594de_vo__tions
diffractions2153274dif_fractions
dilatations1246414d_ilatations
dilations102614454d_il__ations
discolorations17104304discolorations
dislocation14147504dislocation_
distortions1246614distor_tions
donations101112354d___onations
dotations101411634d___otations
duplications1746284duplications
durations10311464d___urations
elaborations1444924elaborations
elations83719124_e_l__ations
elevations1338634_e_levations
elocutions1245964_e_locutions
elongations1244664_e_longations
emigrations14187154_emigrations
etiolations1147394_etiolations
evaporations1744694evaporations
evocations15259874_e_vocations
excoriations2147524_excoriations
execrations2048924_execrations
exfoliations2244784exfoliations
exhortations2244454_exhortations
expirations2069584_expirations
exploration2066714exploration_
exportations2146654_exportations
extortions1746474_extor_tions
federations1548884fe_derations
fellations1338064fe_l_lations
filtrations1445624_filtrations
flirtations14104264__flirtations
floatations1444104__floatations
floriation1367794__floriation_
flotation1267814__flotation_
foliations1399944__foliations
formations1538204__f_ormations
gelations102513094ge_l__ations
generations12311424ge_nerations
idealizations2379454idealizations
infiltrations1653904infiltrations
inflations13310324infl__ations
informations17127034inf_ormations
lobations11219614___lobations
locations112512744___locations
malformations2053074malformations
melioration1368184melioration_
mensurations1445714mensurations
mercurations1646564mercurations
mislocations16145654mislocations
orations81515804____orations
peltations12311554pe_l_tations
penetrations1448854penetrations
percolations1648054percolations
perforation1649004perforation_
peroration12316004pe_roration_
personations1448394personations
preformations2045714pref_ormations
prorations12314464__prorations
realizations21415534realizations
reallocations1553804reallocations
reclamations1645714reclamations
recordations1548644re_cordations
redecorations1645084redecorations
reflation12412334refl__ation_
reflections16178554refl_ections
refloating14198324reflo_ati_ng
reformation1648414ref_ormation_
refractions16127724ref__ractions
refutations1448674ref_utations
rehydrations1943984rehydrations
reiterations12410874reiterations
relations92418334re_l__ations
relaxations1845644re_laxations
relegations1248974re_legations
relocation12312114re_location_
remigrations15227794remigrations
renovations1448424re_novations
reoperations14410064reoperations
reparations13611664re_parations
replications16811054replications
reprobations1647774reprobations
resorptions1347234re_sorptions
respirations14410304respirations
restoration11412094restoration_
retortions1049144re_tor_tions
revocations16410314re_vocations
separations1369274se_parations
serrations10313094se__rrations
suffocations2053094suffocations
sulfonations1543924sulfonations
tolerations1158134_tolerations
venerations14411314ve_nerations

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 Filter1786911247900.420425454.8
2DLD Change Limit1247902427.89015816.2
3Display Results2422420.1431692.3
 (SQL Overall)1786912428.45321139.4
 
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.