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

135 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
bhuts10581295(None) 
bhut95425711bhut_
bouts75131311bouts
bruts75922951bruts
buts67247691b_uts
huts76737441_huts
phuts104613501phuts
shuts85622481shuts
abuts75417072abuts
bahts105617802bahts
baits76630582baits
basts75936932basts
bats66962332b_ats
batts76727562batts
bauds85821042bauds
beats76042242beats
beauts86015282beauts
beets76131442beets
belts75931162belts
bents76033692bents
bests75932612bests
bets67051442b_ets
bhoots11459912bhoots
bints76130182bints
bits66148162b_its
bitts75022592bitts
blats75132502blats
blets75324942blets
blots75626172blots
blubs95818152blubs
blues75127042blues
bluets87215492bluets
blunts84512892blunts
blurs74619082blurs
blurts84412642blurts
boats75635152boats
bolts76232112bolts
boots75837972boots
borts76735452borts
bots66453952b_ots
botts75224862botts
bout66353292bout_
brats75336012brats
brits76433082brits
bruits85714452bruits
brunts85215452brunts
brut66537962brut_
brute75321782brute
brutes86118682brutes
bubs86235502b_ubs
buds75235172b_uds
bugs76035912b_ugs
buhls105111802buhls
buhrs104811242buhrs
bums85934592b_ums
buns66243722b_uns
bunts75729802bunts
burs65847422b_urs
bus56950972b_u_s
buss65134912b_uss
bust65947782b_ust
busts75227692busts
but55963022b_ut_
bute66739672b_ute
butes714535872b_utes
butt65143742b_utt
butts75824252butts
bututs8409422bututs
buys95726792b_uys
chats105730092chats
chits105424572chits
chubs125412622chubs
chugs115511942chugs
chums125015832chums
chute104316462chute
chutes114615772chutes
cuts65841152_cuts
dauts67822242dauts
dhuti937542dhuti
dhutis1035942dhutis
ghats95818612ghats
ghauts10447782ghauts
gluts66120132gluts
gouts64826172gouts
guts56637252_guts
hats76858252_hats
hets75547202_hets
hits75545132_hits
hots78349332_hots
hubs96027142_hubs
hues75235232_hues
hugs86129752_hugs
hums96831422_hums
huns76136932_huns
hunts86826172_hunts
hurts86922822_hurts
hut66457292_hut_
juts115930162_juts
khats125316012khats
khets124913432khets
louts56330272louts
mauts75927192mauts
muts64839982_muts
nuts45032672_nuts
outs45746962_outs
phots105418502phots
phut96925972phut_
pouts75530322pouts
puts65641752_puts
rhus75114052rhu_s
routs57133412routs
ruts44541492_ruts
scuts74522522scuts
shits84731172shits
shots84730852shots
shouts94017722shouts
shuls85319712shuls
shuns85018142shuns
shunts95712022shunts
shut76137592shut_
shute84520352shute
shutes93518222shutes
sluts54523982sluts
smuts75415712smuts
tauts56125512tauts
thuds95110132thuds
thugs95611992thugs
thus76721472thu_s
touts54830392touts
tuts45838452_tuts
uts35534372__uts
whats117718992whats
whets115019612whets
whits115923822whits
whups134210002whups

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 Filter178691538000.313570897.8
2DLD Change Limit538001351.61033416.1
3Display Results1351350.0304500.0
 (SQL Overall)1786911351.95391495.6
 
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.