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

172 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
debeard113735(None) 
debeards1235501debeards
beard86024962__beard
debar85517862deb_ar_
debark134210942deb_ark
debars94218042deb_ars
debeak1336762debea_k
debeaked1634612debeaked
debeaks1436102debeaks
debearded1443372debearded
delead84112342delea_d
reboard10310762reboard
reheard11309022reheard
aboard9312613_aboard
afeard1058263_afeard
bard75648863__b_ard
bead75937923__bea_d
bear66844643__bear_
beards94116673__beards
bears75739043__bears
bebeeru1144263bebeeru
bedboard14115723bedboard
bedward1497473bedward
beeyard1335523beeyard
behead1239923behea_d
beweary1536223beweary
bluebeard1442683bluebeard
board85523003__board
dastard9279703dastard
dead65434243d__ea_d
dear55343603d__ear_
dears65736883d__ears
deary95826843d__eary
debag94212303deb_a_g
debags104211063deb_ags
debarked16175823deb_arked
debarks14388493deb_arks
debarred12165633debarred
debase94014473deb_ase
debased113310583debased
debate94419193deb_ate
debated113916083debated
debearding1543733debearding
debited113311623debited
deboned113411633deboned
debtor938333debtor_
debtors1038533debtors
debuted11379333debuted
decare93919153de_care
decease1049523decease
deceased1247713deceased
decenary1446273decenary
decern91310953dece_rn
deciare10710663deciare
declare10411223declare
declared1248743declared
deed65340903de_e__d
deeded94615543de_eded
deemed104713063de_emed
deer56739023de_e_r_
deers64930523de_e_rs
deeryard1353593deeryard
defeat103817163defea_t
defeated132812163defeated
defeats113511233defeats
defend113910493defe_nd
defer94619753defe_r_
deferred13106363deferred
defers105116943defe_rs
defleaed1344953defleaed
defraud1243913defraud
degerm1037893dege_rm
dekare112811563de_kare
deked115718533deke__d
deleaded1148333deleaded
deleads9379703deleads
deleave1147723deleave
deleaved1346573deleaved
deled75326543dele__d
deleted93314913deleted
demand104314253de_mand
demark134211023de_mark
demean9510563demea_n
demeaned1237283demeaned
demeans1039723demeans
demerara1144853demerara
denar65223293de_nar_
denari710917353de_nari
denars74621433de_nars
denary105316863de_nary
deodand1035713deodand
deodar837713deodar_
deodara945243deodara
deodars937623deodars
depart94720563de_part
depend103510923depe_nd
deperm1139363depe_rm
desand84812633de_sand
desert72725493dese_rt
desexed1636183desexed
deter65028043dete_r_
deterred10137803deterred
deters74724683dete_rs
develed123611933develed
dewar95817733de_war_
dewars105117073de_wars
dewberry1742403dewberry
dewed105020303dewe__d
diehard1237053diehard
discard11310213discard
dogear838193dogear_
dogeared1145793dogeared
dogears937513dogears
dotard839053d_otard
dread74419023d_rea_d
drear65016903d_rear_
drears74614253d_rears
dreary104611673d_reary
dullard936603dullard
echard1249223_echard
gabbard1336553gabbard
heard95222753__heard
inboard1037063inboard
jeopard1744113jeopard
jetbead1742983jetbea_d
kebar115113533keb_ar_
kebars124112493keb_ars
keyboard1844503keyboard
keycard1743663keycard
leeboard1145433leeboard
leeward1135783leeward
leopard1045293leopard
leotard846193leotard
onboard1046503onboard
pegboard1444803pegboard
petard95013803pe_tard
preboard1338263preboard
rebar75420193reb_ar_
rebars84019833reb_ars
reboards1138773reboards
redear73515173redear_
redears82814453redears
reearn6612143re_earn
regard85215773re_gard
regear73512743regear_
regeared1039433regeared
regears83012463regears
rehear93713223rehear_
rehears103312773rehears
relearn747973relearn
reread71715433rerea_d
rereward1246143rereward
retard75018933re_tard
retear63115483retear_
retears72814923retears
reward106017643re_ward
rewear93012003rewear_
rewears102911043rewears
reynard1135123reynard
seaboard1147433seaboard
seaward1148183seaward
sideboard1345173sideboard
tabard9313333tab_ard
teaboard1146293teaboard
unbear889163unbear_
unbeared111611653unbeared
unbears998043unbears
unheard1136943unheard
upbear1096493upbear_
upbears1195423upbears
weber10313523webe_r_
webers11310943webe_rs

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 Limit1340271727.19018640.8
3Display Results1721720.0602866.7
 (SQL Overall)1786911727.65623340.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.