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

110 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
debeards123550(None) 
debeard1137351debeard_
beards94116672__beards
debarks14388492deb_arks
debars94218042deb_ar_s
debeaks1436102debea_ks
debearded1443372debearded
deleads9379702delea_ds
reboards1138772reboards
bards87139643__b_ards
beads85429503__bea_ds
beard86024963__beard_
bears75739043__bear_s
bebeerus1242673bebeerus
bedboards15114873bedboards
bedwards1596393bedwards
beeyards1444593beeyards
beheads1338523behea_ds
bluebeards1542293bluebeards
boards94616933__boards
dastards10278083dastards
deads75726913d__ea_ds
dears65736883d__ear_s
debags104211063deb_a_gs
debar85517863deb_ar__
debark134210943deb_ar_k
debases103814133deb_ases
debates103718533deb_ates
debeak1336763debea__k
debeaked1634613debeaked
debearding1543733debearding
debris93311493deb__ris
debtors1038533debtor_s
decares102818533de_cares
deceases11410153deceases
decerns10119053dece_rns
deciares11510633deciares
declares11611313declares
deeds75423763de_e__ds
deers64930523de_e_r_s
deeryards1452993deeryards
defeats113511233defea_ts
defends12358773defe_nds
defers105116943defe_r_s
defrauds1343243defrauds
degerms1135623dege_rms
dekares122710873de_kares
delead84112343delea_d_
deleaves1248063deleaves
demands114311413de_mands
demarks14339233de_marks
demeans1039723demea_ns
demeraras1243733demeraras
denars74621433de_nar_s
deodands1144603deodands
deodaras1044693deodaras
deodars937623deodar_s
departs104310683de_parts
depends11348993depe_nds
deperms1236603depe_rms
desands94810163de_sands
deserts82513053dese_rts
deters74724683dete_r_s
dewars105117073de_war_s
diehards1346213diehards
discards1238913discards
dogears937513dogear_s
dotards937253d_otards
dreads84115023d_rea_ds
drears74614253d_rear_s
dullards1045493dullards
echards1337963_echards
gabbards1445753gabbards
inboards1145843inboards
jeopards1843683jeopards
jetbeads1842483jetbea_ds
kebars124112493keb_ar_s
keyboards1943963keyboards
keycards1843063keycards
leeboards1244793leeboards
leewards1244983leewards
leopards1144753leopards
leotards945303leotards
pegboards1544023pegboards
petards104311153pe_tards
preboards1446423preboards
rebars84019833reb_ar_s
reboard10310763reboard_
redears82814453redear_s
reearns749103re_earns
regards94112563re_gards
regears83012463regear_s
reheard11309023reheard_
rehears103312773rehear_s
relearns836303relearns
rereads81512293rerea_ds
rerewards1344643rerewards
retards85015003re_tards
retears72814923retear_s
rewards114813993re_wards
rewears102911043rewear_s
reynards1244303reynards
seaboards1246443seaboards
seawards1237203seawards
sideboards1444643sideboards
tabards10310383tab_ards
teaboards1245393teaboards
unbears998043unbear_s
upbears1195423upbear_s
webers11310943webe_r_s

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621107.14020470.9
3Display Results1101100.0502200.0
 (SQL Overall)1786911107.61023481.1
 
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.