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

100 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
zebecks2427419(None) 
rebecks15288011rebecks
zebeck23255201zebeck_
zebecs19316181zebec_s
becks135522012__becks
bedecks1635792bedecks
debeaks1436102debeaks
rebeck14419912rebeck_
rebecs103913672rebec_s
xebecs17355362xebec_s
zebec18419262zebec__
backs135729623__backs
beaks115326623__beaks
beck126226573__beck_
bedeck1536213bedeck_
beflecks1943753beflecks
bemocks1735373bemocks
berks115423123__berks
bocks134526573__bocks
bucks134824293__bucks
chebecs1635013chebec_s
checks174912703_checks
copecks1745873copecks
debarks14388493debarks
debeak1336763debeak_
debunks1433763debunks
decks124822193__decks
defects134511523defects
dejects17389223dejects
detects104011093detects
deticks1437353deticks
diebacks1745963diebacks
drecks13459203_drecks
ebooks12358333_ebooks
ejects15409953_ejects
elects83315003_elects
erects84116183_erects
execs14539723_exec_s
fecks145417853__fecks
flecks154310803_flecks
gecks125117093__gecks
geeks104915843ge_e_ks
hebes105521673hebe__s
hecks145220653__hecks
henpecks1942873henpecks
jebels15418913jebe_ls
kebbocks1743023kebbocks
kebbucks1742353kebbucks
kecks105416573__kecks
keeks84717253ke_e_ks
kopecks1433073kopecks
lebens8310093lebe_ns
leeks95318893le_e_ks
limbecks1843353limbecks
medicks16368413medicks
necks115119333__necks
nubucks1544003nubucks
pecks135724433__pecks
peeks115021113pe_e_ks
rebec94416543rebec__
rebels84518133rebe_ls
rebooks134010513rebooks
rechecks1944553rechecks
recks115625133__recks
recocks154711463recocks
rednecks1544013rednecks
redocks14409933redocks
reeks94124033re_e_ks
refects124012743refects
rejects163910693rejects
relocks134411293relocks
repacks15269543repacks
reperks13298093reperks
reracks132310533reracks
resects94115593resects
reseeks11348623reseeks
retacks132210713retacks
roebucks1643743roebucks
seeks94724643se_e_ks
selects91912143selects
senecas939013senecas
setbacks1686303setbacks
snecks124410033_snecks
specks144312703_specks
tiebacks1646333tiebacks
webers11310943webe_rs
weeks125017863we_e_ks
wetbacks1974983wetbacks
wrecks15418883_wrecks
xebec16378293xebec__
zebras1737853zeb_ras
zebrass1834113zebrass
zebus164610053zeb__us
zees136331893ze_e__s
zeks175815063z__e_ks
zerks185113823z__erks
zibeths2142933zibeths
zibets1737743zibe_ts
zwiebacks2942663zwiebacks
zydecos2241903zydecos

Search took 7 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.1561145455.1
2DLD Change Limit1340271006.68620045.9
3Display Results1001000.0303333.3
 (SQL Overall)1786911006.87226002.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.