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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

136 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
bhut9542571(None) 
bhuts105812951bhuts
bout66353291bout
brut66537961brut
but55963021b_ut
hut66457291_hut
phut96925971phut
shut76137591shut
about75229082about
abut66834952abut
baht96740012baht
bait66556002bait
bast66362412bast
bat510988952b_at
batt65053872batt
baud74928422baud
beat66168302beat
beaut75135212beaut
beet66457542beet
belt65754032belt
bent67759912bent
best66355322best
bet58376672b_et
bhoot104322102bhoot
bint67355042bint
bit57070902b_it
bitt65545812bitt
blat66550952blat
blet66247672blet
blot65842322blot
blub85324872blub
blue65328462blue
bluet75631192bluet
blunt75525022blunt
blur66020532blur
blurt77625622blurt
boat66360312boat
bolt66254172bolt
boot67759372boot
bort65960962bort
bot59680402b_ot
bott66548572bott
bouts75131312bouts
brat66055542brat
brit66350152brit
bruit76126722bruit
brunt75728752brunt
brute75321782brute
bruts75922952bruts
brux136315272brux
bub76343982b_ub
bud67041272b_ud
bug65340742b_ug
buhl95518222buhl
buhr95315382buhr
bum75342692b_um
bun56348142b_un
bunt65850852bunt
bur55744692b_ur
bus56950972b_us
bust65947782bust
bute66739672b_ute
buts67247692b_uts
butt65143742butt
butut75522912butut
buy86436542b_uy
chat95546132chat
chit96937462chit
chub115516412chub
chug105914112chug
chum116318002chum
chute104316462chute
cut57957662_cut
daut56443562daut
dhuti937542dhuti
ghat86435282ghat
ghaut95919432ghaut
glut56331292glut
gout56646002gout
gut46753852_gut
hat67289962_hat
haut75949732haut
het67674312_het
hit66569192_hit
hot67776062_hot
hub86437482_hub
hue66642302_hue
hug76037362_hug
huh96432012_huh
hum85542932_hum
hun65844712_hun
hunt76445492_hunt
hup86437812_hup
hurt77142572_hurt
huts76737442_huts
jut105944012_jut
khat116730722khat
khet116328622khet
lout45952142lout
maut65448452maut
mut58357182_mut
nut36651962_nut
out38072152_out
phat95837862phat
phot95534362phot
pht86030522ph_t
phuts104613502phuts
pout65752552pout
put55759072_put
rhus75114052rhus
rout46153282rout
rut35560522_rut
scut65835542scut
shat76456602shat
shit76745942shit
shot76150262shot
shout85433172shout
shul75823152shul
shun75122772shun
shunt85226512shunt
shute84520352shute
shuts85622482shuts
slut45040592slut
smut66629782smut
taut47048962taut
that75639322that
thud85613912thud
thug86415482thug
thus76721472thus
tout46753822tout
tut36758092_tut
ut28647032__ut
what105434072what
whet105133782whet
whit104834172whit
whup125714162whup

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298721360.87634100.5
3Display Results1361360.0304533.3
 (SQL Overall)1786911361.186150666.9
 
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.