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

211 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
deleave114772(None) 
deleaved1346571deleaved
deleaves1248061deleaves
bereave1258352bereave
cleave114212512_cleave
deave95022332d__eave
decease1049522decease
deceive1337812deceive
delate73827752del_ate
delead84112342delea_d
deleaded1148332deleaded
deleads9379702deleads
delegate10410462delegate
delete73620702dele_te
delve96018262del__ve
deprave1337072deprave
deserve11108702deserve
leave84723722__leave
release7312762release
releve95116402rele_ve
reweave1336772reweave
sleave94714152_sleave
behave14209013be_have
beldame1237233beldame
beleap10410283belea_p
beleaped1336103beleaped
beleaps1138053beleaps
beleapt11310253beleapt
believe12519773believe
belive115415303bel_ive
bereaved1446403bereaved
bereaver1346673bereaver
bereaves1338273bereaves
celeste949653celeste
cellae84915933cella_e
clave105420153_cl_ave
cleaved134010483_cleaved
cleaver124110803_cleaver
cleaves124111623_cleaves
deaerate9314173deaerate
dealate83617843dealate
deaved114916553d__eaved
deaves105319533d__eaves
debase94014473de_base
debate94419193de_bate
debeak1336763debea_k
debeaked1634613debeaked
debeaks1436103debeaks
debeard1137353debeard
decade104216163de_cade
decane93818873de_cane
decare93919153de_care
deceased1247723deceased
deceases11410153deceases
deceived1535893deceived
deceiver1436233deceiver
deceives1437903deceives
deciare10710663deciare
declare10411233declare
decrease1136573decrease
decurve1335583decurve
deface123113863de_face
defame123212433de_fame
defeat103817163defea_t
defeated132812163defeated
defeater122611663defeater
defeats113511233defeats
defecate1438793defecate
defence1339893defence
defense1137503defense
deflate113613943deflate
deflea1037443deflea__
defleaed1344953defleaed
defleas1147223deflea_s
degage92711383de_gage
degame102713183de_game
deglaze1835583deglaze
degrade10229903degrade
degrease1045413degrease
dekare112811563de_kare
delaine8314793delaine
delated93722873del_ated
delates83526283del_ates
delay94820633del_a_y
delayed123310763del_ayed
delayer113010533del_ayer
delays104014053del_ays
dele56843083del___e
deleaving1436263deleaving
delectate1248743delectate
deled75326543dele__d
delegable13136643delegable
delegacy1543533delegacy
delegated1238373delegated
delegatee1148813delegatee
delegates1139843delegates
deleing93313953deleing
deles65139253dele__s
deletable12149503deletable
deleted93314913deleted
deletes83117933deletes
delicate11315493delicate
delime9314043del_ime
delineate1047793delineate
deliver113312243del_iver
delouse839833delouse
delta66117773delta__
deltaic1037023deltaic
deltas74414823delta_s
delude81910673del_ude
deluge8189403del_uge
delusive1245853delusive
deluxe14197303del_uxe
delved114112753del__ved
delver104913493del__ver
delves104917083del__ves
demean9510563demea_n
demeaned1237283demeaned
demeans1039723demeans
demerge11168023demerge
demesne1035573demesne
dentate8315153dentate
deplane10311413deplane
deplete103010423deple_te
depletive1545623depletive
depraved1535543depraved
depraver1435413depraver
depraves1436873depraves
deprive1338303deprive
derate74531233de_rate
derive103817043de_rive
deserved13108133deserved
deserver12118383deserver
deserves12109893deserves
detente83313603detente
deterge9118463deterge
deviate11312713deviate
devolve14316063devolve
dilate73220693dil_ate
disease83213843disease
dissave1139413dissave
drave95219273d__rave
eave75733583___eave
elate55335883_el_ate
elevate101110373_elevate
eleven988303_ele_ven
eluate62315433_eluate
fellate10313433fellate
galeae74717453galea_e
galeate83916793galeate
gelate73421263gel_ate
gelee63626983gele__e
greave104611493_greave
heave114521813__heave
helve115018093hel__ve
inweave1344723inweave
keelage1236193keelage
keeve124512133ke_e_ve
lave75642143__l_ave
lease55230263__lease
leaved105719023__leaved
leaven95013073__leaven
leaver94321513__leaver
leaves94222383__leaves
leavy115715773__leavy
maleate94117543maleate
melee73729103mele__e
meltage1037953meltage
mileage10299313mileage
oleate6318883_oleate
paleae84820293palea_e
paleate94120003paleate
peeve104915253pe_e_ve
pelage9515363pel_age
peltate92013773peltate
pileate93815923pileate
please84315733_please
poleaxe1656303poleaxe
reave84528023__reave
receive1239733receive
reeve84121323re_e_ve
regave104713383re_gave
relace83122153rel_ace
relate64033633rel_ate
relearn747973relearn
released9310243released
releaser839503releaser
releases8313343releases
relegate9311243relegate
releves103914973rele_ves
relieve105010693relieve
relive95120783rel_ive
repave114813873re_pave
reserve101011203reserve
reshave1338603reshave
reweaved1535953reweaved
reweaves1436603reweaves
selenate81712533selenate
selvage1136553selvage
sheave124514003_sheave
slave84224033_sl_ave
sleaved113611133_sleaved
sleaves103813203_sleaves
sleaze152611863_sleaze
sleeve93411593_sleeve
telae54323293tel_a_e
unweave1336363unweave
upheave1544023upheave
velate93720143vel_ate
weave115218533__weave
welfare1335723welfare

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272116.59620319.4
3Display Results2112110.0762776.3
 (SQL Overall)1786912117.07825246.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.