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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
besmokes1640636(None) 
besmoke15416621besmoke_
besmoked17405411besmoked
besmiles1237392besmiles
bespoke15468112bespoke_
bespoken16505012bespoken
restokes125213042restokes
smokes124814342__smokes
becomes132911963be_comes
bedmaker1744933bedmaker
bedmakers1844383bedmakers
bedmates1349183bedmates
bedsores1157633bedsores
behooves1653793behooves
behoves15177353be_hoves
bemires113212833be_mires
bemixes18338653be_mixes
bemoans1138253be_moans
bemocked1934073be_mocked
bemocks1735373be_mocks
bemuses1139293be_muses
benzoles1936993benzoles
berakes134815773be_rakes
bermes106023003berm__es
bescours1245093bescours
beses75830723bes___es
beshames1537203beshames
beshouts1346763beshouts
besides104814533bes_ides
besieges1146003besieges
beslimes1246953beslimes
besmears1234543besmears
besmile1137463besmile_
besmiled1335503besmiled
besmoking18114613besmoking
besmooth1543353besmooth
besmooths1642593besmooths
besmudges1542413besmudges
besmuts1134683besm_uts
besnowed14124413besnowed
besnows1245153besno_ws
besoms105712733bes_o_ms
besoothes1443763besoothes
besots86415453bes_o_ts
bespake15436963bespake_
bespouse1245113bespouse
bespouses1345153bespouses
bestowed14156623bestowed
bestower13126213bestower
bestowers14135333bestowers
bestows1248863besto_ws
betakes134212523be_takes
betoken13386503be_token
betokens14324573be_tokens
blesboks1643043blesbok_s
blokes123813883b__lokes
cestodes1138203cestodes
cosmoses1239703cosmoses
demoses103815823de_moses
demotes104717673de_motes
desmoids1244973desmoids
disyokes1656503disyokes
emotes84620283_e_motes
evokes13459683_e_vokes
gemotes103712143ge_motes
gessoes838293gesso_es
mismakes16129883mismakes
mismoves1537293mismoves
misyokes1735513misyokes
mokes114631033___mokes
osmoles9138363_osmoles
osmoses9138123_osmoses
outsmokes1545313outsmokes
oversmokes1944703oversmokes
reevokes15375993reevokes
remakes134116173re_makes
remotes94521613re_motes
removes124514713re_moves
rescores105415693rescores
reshoes102316033resho_es
resoles73823653res_oles
respoke134311283respoke_
respoken14506923respoken
restoke116113903restoke_
restoked135710533restoked
restores85222993restores
revokes144212503re_vokes
smoke115015823__smoke_
smoked134311723__smoked
smoker124311693__smoker
smokers13389323__smokers
smokey15398653__smokey
sokes95031423__s_okes
spokes124417213__spokes
stokes104821793__stokes
unsmoked1536013unsmoked

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.423422437.4
2DLD Change Limit146162967.40619735.6
3Display Results96960.0303200.0
 (SQL Overall)178691967.85922737.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.