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

191 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
bahts10561780(None) 
baht96740011baht_
baits76630581baits
basts75936931basts
baths105922921baths
bats66962331ba_ts
batts76727561batts
aahs716428562aah_s
abets75621672abets
abuts75417072abuts
acts66929862_acts
ahis76135382_ahis
ahs68644822_ah_s
aits46355532_aits
alts46639902_alts
ants47243472_ants
arts49650262_arts
baals76122702baals
baas66844672ba_as
babas96325732babas
babes95834112babes
babus95620332babus
baches135426942baches
backs135729622backs
bads77048862ba_ds
baffs134718052baffs
bags76645502ba_gs
bah87755352bah__
bails75933522bails
bait66556002bait_
baith108023132baith
bakes117035372bakes
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042ba_ls
bams87044452ba_ms
bands85233422bands
banes74945582banes
bangs85627772bangs
banks115527902banks
banns75321232banns
bans66555132ba_ns
banty106624002banty
baps86040842ba_ps
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092ba_rs
bas58681752ba__s
bases75644352bases
bashes115631392bashes
basis75429862basis
basks115621762basks
bass66146782ba_ss
bast66362412bast_
baste74829982baste
bastes85330382bastes
bat510988952ba_t_
bate66552422ba_te
bates75846342bates
bath95940082ba_th
bathe105822882bathe
bathes116524832bathes
bathos116215632bathos
batt65053872ba_tt
battu75216612battu
batty105422242batty
bauds85821042bauds
bawds116115492bawds
bawls105719322bawls
bawty135614102bawty
bays97143912ba_ys
beasts84519722beasts
beats76042242beats
beauts86015282beauts
beets76131442beets
belts75931162belts
bents76033692bents
bests75932612bests
beths105519222beths
bets67051442b_ets
bhuts105812952bhuts
bights124417962bights
bints76130182bints
bits66148162b_its
bitts75022592bitts
blahs105616512blah_s
blasts85116772blasts
blats75132502blats
blets75324942blets
blots75626172blots
boarts84716872boarts
boasts85017922boasts
boats75635152boats
bohos105618252bohos
bolts76232112bolts
boots75837972boots
borts76735452borts
bots66453952b_ots
botts75224862botts
bouts75131312bouts
bracts105617772bracts
brants85723052brants
brats75336012brats
brits76433082brits
bruts75922952bruts
buhls105111802buhls
buhrs104811242buhrs
bunts75729802bunts
busts75227692busts
buts67247692b_uts
butts75824252butts
cants77036942cants
carts78946292carts
casts77237792casts
cats66356342ca_ts
chats105730092chats
dahls95012282dahls
dahs88231812dah_s
darts67635732darts
dauts67822242dauts
dawts97216122dawts
easts57530322easts
eats47054872ea_ts
facts107021892facts
farts88336842farts
fasts86429682fasts
fats76252502fa_ts
gaits65726012gaits
gasts66628632gasts
gats56753442ga_ts
ghats95818612ghats
haets86525122haets
hafts116219462hafts
hahas117118442hahas
hahs108333362hah_s
halts85230102halts
hants86335402hants
harts88441592harts
hats76858252ha_ts
karts97630112karts
kats85944332ka_ts
khats125316012khats
lasts57731262lasts
laths86022402laths
lats45962702la_ts
malts76331752malts
marts77442232marts
masts77035762masts
maths105624022maths
mats65460282ma_ts
matts76829182matts
mauts75927192mauts
oasts56529182oasts
oaths86117312oaths
oats46554212oa_ts
pacts95125802pacts
pants76536922pants
parts77743372parts
pasts75936502pasts
paths105521382paths
pats66460852pa_ts
qats135331342qa_ts
rafts87820632rafts
rants55935342rants
rats46260372ra_ts
salts55431882salts
tacts76524122tacts
tahrs85412332tahrs
tarts57242022tarts
tats46858132ta_ts
tauts56125512tauts
vasts86423772vasts
vats76841742va_ts
wafts116920552wafts
waits88333522waits
wants87932212wants
warts814840402warts
wasts87433672wasts
wats77555882wa_ts
watts86923092watts
whats117718992whats
yachts1437022yachts

Search took 3 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.1231452772.4
2DLD Change Limit538001912.18624611.2
3Display Results1911910.0633031.7
 (SQL Overall)1786911912.37275333.5
 
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.