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

254 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
debeak133676(None) 
debeaks1436101debeaks
beak106534382__beak
debag94212302deb_ag
debar85517862deb_ar
debark134210942debark
debeaked1634612debeaked
debeard1137352debeard
debunk1365112debunk
defeat103817162defeat
delead84112342delead
demean9510562demean
rebeck14419912rebeck
zebeck23255202zebeck
abeam9316533_abeam
amebean1144853amebean
apeak115513453_apeak
bead75937923__bead
beaks115326623__beaks
beaky146118023__beaky
beam86939233__beam
bean66443863__bean
bear66844643__bear
beat66168303__beat
beau66137273__beau
beck126226573__beck
bedeck1536213bedeck
behead1239923behead
beleap10410283beleap
bemean10410683bemean
berk105929843__berk
bespeak1544573bespeak
bleak115915383_bleak
break115319403_break
cereal8315833cereal
creak115418433_creak
dak86340693d___ak
daybreak1842333daybreak
dead65434243d__ead
deadbeat1245803deadbeat
deaf85838403d__eaf
deal56347413d__eal
dean56039483d__ean
dear55343603d__ear
deb66342693deb___
debags104211063debags
debarks14388493debarks
debars94218043debars
debase94014473debase
debate94419193debate
debeaking1735923debeaking
debeards1235503debeards
debit85727853deb_it
debits94214503debits
debone93714783debone
debris93311493debris
debs76530243deb__s
debt77139023deb__t
debtor938333debtor
debts86418373deb_ts
debug94210063deb_ug
debugs10467823debugs
debunks1433763debunks
debut86024143deb_ut
debuts93911753debuts
debye1138903deb_ye
debyes1238103debyes
decaf114919443de_caf
decal85523233de_cal
decay114718483de_cay
decease1049523decease
deceit93018213deceit
decent94023703decent
decern91310953decern
deck115827753d__eck
declaw1266703declaw
dedal75719023de_dal
dee47665823de_e__
deed65340903de_e_d
deeds75423763de_eds
deedy104315893de_edy
deejay1734523deejay
deem75432893de_e_m
deems85421773de_ems
deep76031883de_e_p
deeps84921773de_eps
deer56739023de_e_r
deers64930523de_ers
dees56356633de_e_s
deet57356583de_e_t
deets65330243de_ets
deewan10267553deewan
defat95426693de_fat
defeats113511233defeats
defect124816173defect
defend113910493defend
defer94619753defe_r
defers105116943defers
deflea1037443deflea_
defleas1147223defleas
defoam1238563defoam
defrag1136463defrag
defray1337643defray
degas75119163de_gas
degerm1037893degerm
deject164512843deject
deke95228763deke__
deked115718533deke_d
dekes105224453deke_s
delay94820633de_lay
dele56843083dele__
deleads9379703deleads
deleave1147723deleave
deled75326543dele_d
deles65139253dele_s
delete73620703delete
delta66117773delta_
deltas74414823deltas
demark134211023demark
deme76536283deme__
demeans1039723demeans
dement93825153dement
demes86032693deme_s
denar65223293de_nar
dene56643413dene__
denes65639723dene_s
denial74720513denial
dental74319173dental
deodar837713deodar
depend103510923depend
deperm1139363deperm
derat65044083de_rat
deray95024183de_ray
dere56845903dere__
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
desert72725493desert
desex13311983dese_x
desk95618903d__esk
desman9311693desman
detect94217403detect
detent73624483detent
deter65028043dete_r
deters74724683deters
detest74122843detest
detick1339383detick
deva85720983de_va_
devas96218883de_vas
devein1039143devein
devel94217123deve_l
devels104313903devels
devest104418703devest
dewan95718043de_wan
dewar95817733de_war
dewax165510853de_wax
dewed105020303dewe_d
dewlap1264843dewlap
dexes135224513dexe_s
dhak125512033d__hak
dibbuk1543503dibbuk
dieback1646913dieback
djebel1643453djebe_l
djebels1753293djebels
dobla84913643dobla_
doblas93812293doblas
dobra85013103dobra_
dobras94811913dobras
dogear838193dogear
dread74419023d_read
dream85120393d_ream
drear65016903d_rear
dreck124812803d_reck
drek96321093d_re_k
dybbuk1841753dybbuk
ebook114510803_ebook
eek77935103_e_e_k
eyebeam1443563eyebeam
freak125115243_freak
geek95327023ge_e_k
hebe96424703hebe__
hebes105521673hebe_s
hereat93527413hereat
jebel145612143jebe_l
jebels15418913jebels
jetbead1742983jetbead
kebab134312003keb_ab
kebar115113533keb_ar
keblah1545313keblah
keek75624973ke_e_k
leak86233713__leak
leben7314853lebe_n
lebens8310093lebens
leek85331733le_e_k
meek105624833me_e_k
obeah1038993_obeah
peak106535203__peak
peek106031433pe_e_k
perea75026443perea_
phreak1536153phreak
rebar75420193reb_ar
rebec94416543rebe_c
rebecks15288013rebecks
rebecs103913673rebecs
rebegan1045953rebegan
rebel73421293rebe_l
rebels84518133rebels
rebook125213203rebook
redear73515173redear
reek85232523re_e_k
regear73512743regear
rehear93713223rehear
reheat94423943reheat
repeal84718283repeal
repeat85127213repeat
reperk122511773reperk
reread71715433reread
reseal64819643reseal
reseat64131493reseat
reseau64216213reseau
reseek103813133reseek
resoak10311093resoak
respeak1335933respeak
reteam83214533reteam
retear63115483retear
reveal94115053reveal
rewear93012003rewear
screak125311063screak
seek85935483se_e_k
shebean1235763shebean
sneak96016173_sneak
speak114618673_speak
squeak1935253squeak
steak95219803_steak
streak104613623streak
teak85930843__teak
tiebreak1442953tiebreak
tweak1257753_tweak
unbear889163unbear
upbear1096493upbear
upbeat10911513upbeat
weak117126303__weak
webcam1545543webcam
weber10313523webe_r
webers11310943webers
week116428153we_e_k
wreak125513273_wreak
xebec16378293xebe_c
xebecs17355363xebecs
zebec18419263zebe_c
zebecks24274193zebecks
zebecs19316183zebecs
zebra1637883zebra_
zebras1737853zebras

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162545.45320670.5
3Display Results2542540.0803175.0
 (SQL Overall)1786912545.90630255.8
 
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.