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

356 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
bait6655600(None) 
ait38093901_ait
baht96740011baht
bail65042801bail
baith108023131baith
baits76630581baits
bast66362411bast
bat510988951ba_t
batt65053871batt
bit57070891b_it
brit66350151brit
gait56150191gait
wait75553691wait
abaft10318062abaft
abet610547942abet
abut66834952abut
act59557842_act
adit56443652adit
aft66849012_aft
ai211288392_ai_
aid49269072_aid
ail37171042_ail
aim57858212_aim
ain37579092_ain
air38058392_air
airt45757782_airt
ais39083572_ais
aits46355532_aits
alit46155692alit
alt36467962_alt
ant37270782_ant
apt57352542_apt
art38679142_art
at212393402_a_t
att35454652_att
await85524492await
ba49962342ba__
baa510650422ba_a
baal67033112baal
baas66844672baas
baba88828342baba
babe86835812babe
babu85829222babu
baby116723672baby
bach116131392bach
back125535762back
bad67763152ba_d
bade75140882bade
bads77048862bads
baff124632262baff
bag67059222ba_g
bags76645502bags
bah87755352ba_h
bahts105617802bahts
bails75933522bails
bairn77515532bairn
baited95319242baited
baiter84422552baiter
baiza164813222baiza
baize164717392baize
bake105637512bake
bal56662722ba_l
bald76432902bald
bale66353842bale
balk105132222balk
ball66043322ball
balm85534202balm
bals66354042bals
bam78560142ba_m
bams87044452bams
ban58366832ba_n
band76740902band
bandit93821132bandit
bane65250422bane
bang74836992bang
bani65334952bani
bank105835742bank
bankit123617042bankit
bans66555132bans
banty106624002banty
bap76455842ba_p
baps86040842baps
bar58070552ba_r
barb85240062barb
bard75648862bard
bare65460522bare
barf95844402barf
baric96125692baric
barite84224812barite
bark106242152bark
barm86739602barm
barn66444642barn
bars66564092bars
bas58681752ba_s
base64847022base
bash915240162bash
basic96220522basic
basil75122272basil
basin75026922basin
basis75429862basis
bask105131422bask
bass66146782bass
baste74829982baste
basts75936932basts
bate66552422bate
bath95940082bath
batik11614732batik
bats66962332bats
batts76727562batts
battu75216612battu
batty105422242batty
baud74928422baud
bawd105520842bawd
bawl95326062bawl
bawty135614102bawty
bay89661642ba_y
bays97143912bays
beast76338642beast
beat66168302beat
beaut75135212beaut
beet66457542beet
befit105222662befit
belt65754032belt
bent67759912bent
best66355322best
bet58376672b_et
bhut95425712bhut
bi48046462b_i_
bias64738152bias
bib77045922b_ib
bid67751782b_id
big67345712b_ig
bin56658632b_in
binit76431582binit
bint67355032bint
bio57846072b_io
bis56860652b_is
bite66546992b_ite
bits66148152b_its
bitt65545802bitt
biz147939352b_iz
blain75421792blain
blast76532572blast
blat66550952blat
blet66247672blet
blin67228172blin
blip88322772blip
blite76225352blite
blitz165318132blitz
blot65842322blot
boart78835932boart
boast75935702boast
boat66360312boat
boil66335182boil
boite74426322boite
bolt66254172bolt
boot67759372boot
bort65960962bort
bot59680402b_ot
bott66548572bott
bout66353292bout
bract96332722bract
braid85822262braid
brail75525552brail
brain76229382brain
brant74742172brant
brat66055542brat
brie65837902brie
brig76528032brig
brim85629372brim
brin67038192brin
brio65432492brio
bris65539612bris
brith104924372brith
brits76433082brits
britt75732232britt
bruit76126722bruit
brut66537962brut
built74325922built
bunt65850852bunt
bust65947782bust
but55963022b_ut
butt65143742butt
caid77837532caid
cain65643912cain
cant66362022cant
cart66570342cart
cast67159902cast
cat58282342ca_t
chit96937462chit
crit65743712crit
daft85537252daft
dais57040702dais
dart55857872dart
daut56443562daut
davit93424592davit
dawt85435942dawt
dit47071332_dit
doit56347852doit
duit56241582duit
east46659102east
eat36989052ea_t
edit54934862edit
emit65438412emit
exit114428672exit
fact97142542fact
fail74840242fail
fain75840562fain
faint85837062faint
fair76332522fair
faith115620852faith
fart76860562fart
fast77052312fast
fat68178082fa_t
fiat76646642fiat
fit66365452_fit
flit76539272flit
frit77044472frit
gain56042162gain
gaits65726012gaits
gast56052562gast
gat46880512ga_t
git46266052_git
grit55247242grit
habit103027012habit
haet75659502haet
haft105941842haft
haik115526982haik
hail74839062hail
haint85436322haint
hair76330142hair
halt76056302halt
hant75461582hant
hart76865772hart
hast76259482hast
hat67289962ha_t
haut75949732haut
hit66569192_hit
it28455682__it
jail115529092jail
kaif116933922kaif
kail85131492kail
kain85334292kain
kart86750802kart
kat77468292ka_t
kit78559872_kit
knit85728142knit
krait94726772krait
laic65931562laic
laid56439142laid
lain46146282lain
lair45934152lair
laith85722102laith
laity85318902laity
last46260322last
lat37593402la_t
lati46438272lati
lit39377312_lit
maid75537632maid
mail65543432mail
maim85831472maim
main65345502main
mair66133762mair
maist75535672maist
malt66254802malt
mart66865972mart
mast65959952mast
mat58083932ma_t
matt65752652matt
maut65448442maut
naif76839012naif
nail45838652nail
nit37065942_nit
oast47156322oast
oat39888262oa_t
obit66837072obit
omit65337362omit
pact86648722pact
paid75737482paid
paik105726802paik
pail66141832pail
pain65647242pain
paint75443692paint
pair66031512pair
pant66061252pant
part65967462part
past65959012past
pat58089462pa_t
pit56471922_pit
plait75631572plait
qaid146023842qaid
qat125253332qa_t
quit136136512quit
raft76245912raft
rai37658222rai_
raia46638382raia
raid55243072raid
rail46147762rail
rain46251732rain
rais45252622rais
raita54623072raita
rant45864672rant
rapt67245312rapt
rat37892742ra_t
rebait8320402rebait
said55742112said
sail45447162sail
sain45551292sain
saint55147072saint
saith85826552saith
salt45758522salt
sat36288482sa_t
sati45539322sati
shit76745932shit
sit35877752_sit
skit85437522skit
slit46250102slit
smit65138402smit
snit46342472snit
spait75631602spait
spit65545082spit
suit45649872suit
tacit76333672tacit
tact67349032tact
tail45443652tail
tain45548072tain
taint55542282taint
tart47566182tart
tat37690292ta_t
taut47048962taut
tit36771042_tit
toit46353062toit
trait56940842trait
twit76329062twit
unit45140072unit
vail75432552vail
vain75233002vain
vair75624142vair
vast75045122vast
vat67863452va_t
waft106139002waft
waif105836742waif
wail75238822wail
wain75840192wain
wair75830052wair
waist86132382waist
waits88333522waits
want76156162want
wart77866082wart
wast75655852wast
wat67378922wa_t
watt75545412watt
whit104834172whit
wit66563772_wit
writ75537912writ
zit126049992_zit

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.0802233637.5
2DLD Change Limit298723561.06028181.1
3Display Results3563560.0963708.3
 (SQL Overall)1786913561.236144572.0
 
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.