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

114 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
bethank166627(None) 
bethanks1765311bethanks
bethink1677201bethink
bechalk1845812bechalk
bethanked1943282bethanked
bethinks1765042bethinks
ethane94613242_ethane
methane123211792methane
rethink1488882rethink
thank125817802__thank
bank105835753b___ank
bathing134816243bathing
batman105214063batman_
beak106534383be__a_k
bean66443863be__an_
beano75421553be__ano
beans75734693be__ans
bechalks1944793bechalks
bechance1747743bechance
becharm1636843becharm
bedpan1137583bedpan_
bedpans1237173bedpans
began86319573be_gan_
behalf14310953be_half
behave14209013be_have
behind1238063be_hind
bemean10410683bemean_
bemeans1148743bemeans
bemoan10310253bemoan_
bemoans1138253bemoans
benthal1247963bentha_l
benthon1237693benthon_
benthons1337973benthons
bertha11429173bertha__
berthas12398763bertha_s
berthing14209603berthing
beshame1447483beshame
beta66234133bet_a__
betaine9413783betaine
betake124512703bet_ake
betas75528763bet_a_s
beth96629233beth___
bethanking2044293bethanking
bethel1169643beth_el
bethels1238533bethels
bethorn1238643bethorn
bethorns1337323bethorns
beths105519223beth__s
bethump1642823bethump
beton76022063bet_on_
betons84919553bet_ons
betony114211583bet_ony
betook12439603bet_ook
betray111511443betra_y
betrays12127823betrays
betta74916843betta__
bettas84913923betta_s
betting103921403betting
bezant17814543be_zant
bezzant1746893bezzant
bhang115512923b__hang
blank115418553b__lank
bohunk1533743b_ohunk
botany1139263bot_any
brank115222283b__rank
brechan1437223brechan_
brechans1547413brechans
butane8313653but_ane
bytalk1533473byt_alk
cetane8315283cet_ane
cutbank1545533cutbank
embank14346553_embank
etchant1249823_etchant
ethanes103713513_ethanes
ethanol1044593_ethanol
ethene93312923_ethene
ethyne12407153_ethyne
futhark1744233futhark
hank115134143___hank
hetman112510603hetman_
hetmans12187593hetmans
lethal939803letha_l
lethals1038113lethals
lethean1037093lethean_
methanes133812163methanes
methanol1344643methanol
methinks1775193methinks
outrank112611973outrank
outthank1544353outthank
pechan13511543pechan_
pechans14810503pechans
redshank1642893redshank
rehang1039823re_hang
retack122612823ret_ack
rethinks1576033rethinks
retrack131310723retrack
setback1567143setback
shank125422193__shank
stank95823303_st_ank
tank85134033__t_ank
tetany959843tet_any
thack144915173__thack
than76128773__than_
thane86122533__thane
thanks134313133__thanks
think125018803__think
thunk124911853__thunk
trank96222423__trank
unthink1457003unthink
urethan1045473urethan_
urethane1145433urethane
urethans1145243urethans
wetback1875613wetback
wetland1135353wetland

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.453394461.4
2DLD Change Limit1340271147.14018771.3
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.63923391.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.