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

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

212 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
deleaves124806(None) 
deleave1147721deleave_
deleaved1346571deleaved
bereaves1338272bereaves
cleaves124111622_cleaves
deaves105319532d__eaves
deceases11410152deceases
deceives1437902deceives
delates83526282del_ates
deleaded1148332deleaded
deleads9379702delea_ds
delegates1139842delegates
deletes83117932dele_tes
delves104917082del__ves
depraves1436872depraves
deserves12109892deserves
leaves94222382__leaves
releases8313342releases
releves103914972rele_ves
reweaves1436602reweaves
sleaves103813202_sleaves
beeves114615043be_e_ves
behaves15198523be_haves
beldames1336803beldames
beleaped1336103beleaped
beleaps1138053belea_ps
believes13449403believes
bereave1258353bereave_
bereaved1446403bereaved
bereaver1346673bereaver
bereavers1446123bereavers
celeries10316313celeries
celestes10310013celestes
claves115020063_cl_aves
cleave114212513_cleave_
cleaved134010483_cleaved
cleaver124110803_cleaver
cleavers13398873_cleavers
deaerates10313643deaerates
dealates92716683dealates
deave95022333d__eave_
deaved114916553d__eaved
debases103814133de_bases
debates103718533de_bates
debeaked1634613debeaked
debeaks1436103debea_ks
debeards1235503debeards
decades113615513de_cades
decanes103118913de_canes
decares102818533de_cares
decease1049523decease_
deceased1247713deceased
deceive1337813deceive_
deceived1535893deceived
deceiver1436233deceiver
deceivers1535723deceivers
deciares11510633deciares
declares11611313declares
decreases1237223decreases
decurves1435863decurves
defaces133213403de_faces
defames132812253de_fames
defeated132812163defeated
defeater122611663defeater
defeaters13289103defeaters
defeats113511233defea_ts
defecates1538593defecates
defences1439633defences
defenses1237913defenses
deflates123013943deflates
defleaed1344953deflea_ed
defleas1147223deflea__s
degames113312623de_games
degases93413103de_gases
deglazes1935463deglazes
degrades11269923degrades
degreases1146153degreases
dekares122710873de_kares
delaines9312963delaines
delate73827753del_ate_
delated93722873del_ated
delayed123310763del_ayed
delayer113010533del_ayer
delayers12268663del_ayers
delays104014053del_a_ys
delead84112343delea__d
deleaving1436263deleaving
delectates1348193delectates
delegacies1444033delegacies
delegate10410463delegate_
delegated1238373delegated
delegatee1148803delegatee
delegatees1244273delegatees
deles65139253del___es
delete73620703dele_te_
deleted93314913dele_ted
delicates12314313delicates
delimes10314193del_imes
delineates1147123delineates
deliver113312243del_iver
delivers123310753del_ivers
dellies83622213del_lies
delouses9310013delouses
deltas74414823delta__s
deludes91810643del_udes
deluges9169263del_uges
delve96018263del__ve_
delved114112753del__ved
delver104913493del__ver
delvers113411993del__vers
demeaned1237283demeaned
demeans1039723demea_ns
demerges12129503demerges
demesnes1137083demesnes
deplanes11311213deplanes
depletes112810643deple_tes
deprave1337073deprave_
depraved1535543depraved
depraver1435413depraver
depravers1534683depravers
deprives1438393deprives
derates84028893de_rates
derives114017813de_rives
deserve11108703deserve_
deserved13108133deserved
deserver12118383deserver
deservers13107293deservers
desexes1537833dese_xes
detentes92712873detentes
deterges101510093deterges
deviates12312733deviates
devolves15286263devolves
dewaxes18297843de_waxes
dilates83220663dil_ates
diseases92415813diseases
dissaves1239413dissaves
distaves12311403distaves
dolmades1245463dolmades
eaves85231993___eaves
elates65032363_el_ates
elegies81312903_elegies
elevates111110423_elevates
eleven988303_ele_ven
elevens1066803_ele_vens
eluates72014683_eluates
elves85118743_el__ves
endleaves1343563endleaves
fellates11312753fellates
flyleaves1841263flyleaves
gelates83219583gel_ates
gelees74116263gele__es
greaves113311443_greaves
heaves124120303__heaves
helves124316063hel__ves
inweaves1445043inweaves
keelages1335743keelages
keeves133711993ke_e_ves
laves86039153__l_aves
leases65428113__leases
leave84723723__leave_
leaved105719023__leaved
leaven95013073__leaven
leavens10409303__leavens
leaver94321513__leaver
leavers103717783__leavers
loaves94813853__loaves
maleates103316343maleates
melees83618083mele__es
meltages1148243meltages
mileages11249693mileages
oleates7417833_oleates
peeves113814873pe_e_ves
pelages10714613pel_ages
pelves114514663pel__ves
pleases94515483_pleases
poleaxes1767273poleaxes
reaves94127573__reaves
receives1339743receives
reeves94721493re_e_ves
relaces93420883rel_aces
relates73731433rel_ates
relaxes143215323rel_axes
relearns836303relearns
release7312763release_
released9310243released
releaser839503releaser
releasers937323releasers
relegates10310943relegates
releve95116403rele_ve_
relieves114210393relieves
relives104619443rel_ives
repaves123513653re_paves
reserves111011983reserves
reshaves1438733reshaves
reweave1336773reweave_
reweaved1535953reweaved
selenates91611363selenates
selvages1236513selvages
selves94119613sel__ves
sheaves134412973_sheaves
slaves95023023_sl_aves
sleave94714153_sleave_
sleaved113611133_sleaved
sleazes162810333_sleazes
sleeves103311343_sleeves
telefaxes1943813telefaxes
teleses7313123tele_ses
telexes1438353tele_xes
unweaves1436143unweaves
upheaves1643913upheaves
weaves123616373__weaves
welfares1445543welfares

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 Filter1786911461620.453394461.4
2DLD Change Limit1461622127.58019282.6
3Display Results2122120.0932279.6
 (SQL Overall)1786912128.12621990.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.