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

237 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
efts7651948(None) 
eats47054871eats
effs105114031effs
efs66829601ef_s
eft66038821eft_
fets75345941fets
hefts116218151hefts
lefts86517811lefts
wefts116715491wefts
acts66929862acts
aft66849012aft_
aits46355532aits
alts46639902alts
ants47243472ants
arts49650262arts
bats66962332bats
beats76042242beats
beets76131442beets
befits114711502befits
belts75931162belts
bents76033692bents
bests75932612bests
bets67051442bets
bits66148162bits
bots66453952bots
buts67247692buts
cats66356342cats
celts75325782celts
cents74730332cents
clefts114610162clefts
cots68054842cots
cuts65841152cuts
debts86418372debts
deets65330242deets
defats105114552defats
defis96717502defis
deft85540222deft_
delfts10439672delfts
delts65731792delts
dents65031802dents
dits56450522dits
dots55647662dots
ears46356592ears
east46659102east
easts57530322easts
eat36989052eat_
eath75735662eath
ebbs82411992ebbs
ecus65421462ecus
edhs86212102edhs
edits65819032edits
eds46638922e_ds
eels46536742eels
ef57345362ef__
eff96128622ef_f
eggs66516152eggs
egis56520652egis
egos55821652egos
ekes86726602ekes
elds56324852elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
emes65434662emes
emits75421472emits
ems56435492e_ms
emus66821682emus
ends56528522ends
engs56121392engs
ens37245922e_ns
eons46638712eons
epos66723732epos
eras45441502eras
ergs55523812ergs
erns45428222erns
eros45238452eros
errs45622532errs
ers36046282e_rs
erst47436432erst
es29048222e__s
eses45336102eses
ess36030882e_ss
et26964192e_t_
eta35834192e_ta
etas46432272etas
eth66630982e_th
eths76619522eths
eves76230462eves
ewes76328702ewes
exes116530812exes
exits125515912exits
eyas76427432eyas
eyes75837882eyes
fas68262932_fas
fats76252502fats
feats86432752feats
feds85234312feds
fees76450602fees
fehs106522382fehs
felts85324542felts
fems96428702fems
fens76139762fens
fes66551672_fes
fess76529162fess
fest74949442fest
fests85828042fests
fet66471632fet_
feta76528902feta
fetas85624402fetas
fete75734922fete
fetes85630142fetes
fetus85816542fetus
feus75830752feus
fits76043462fits
gats56753442gats
gelts65924612gelts
gents65729612gents
gests66028812gests
gets55442482gets
gifts96214962gifts
gits55744592gits
guts56637252guts
hafts116219462hafts
hats76858252hats
heats85838402heats
heft106736292heft_
hefty146112132hefty
hents87330742hents
hests85829932hests
hets75547202hets
hits75545132hits
hots78349322hots
huts76737442huts
ifs67124242if_s
its35538832_its
jefes155613672jefes
jests125922452jests
jets115834102jets
jots116336142jots
juts115930162juts
kats85944332kats
keets95123482keets
kefs115922742kef_s
kelts95222632kelts
kits86441762kits
lats45962702lats
leets54927122leets
left76340482left_
lefty115613562lefty
lets47147942lets
lifts85719062lifts
lits46252492lits
lofts85518362lofts
lots47652092lots
mats65460282mats
meats75034052meats
meets74224612meets
melts74930102melts
mots66853162mots
muts64839982muts
neats55931902neats
nerts55924982nerts
nests55728002nests
nets45941532nets
netts55320722netts
newts86015282newts
nits45741642nits
nuts45032672nuts
oats46554212oats
offs107117012offs
oft67744062oft_
oots46446442oots
opts68124742opts
orts46538332orts
outs45746962outs
pats66460852pats
peats76140192peats
pelts76128812pelts
pests75933272pests
pets66248332pets
pits66348742pits
pots66452362pots
puts65641752puts
qats135331342qats
rafts87820632rafts
rats46260372rats
refits94017652refits
refs75732242ref_s
reft75141272reft_
rents55935182rents
rests54935872rests
rets45352562rets
rifts85718642rifts
rots46454092rots
ruts44541492ruts
seats54844342seats
sects75622892sects
septs75420602septs
sets45549502sets
setts55124322setts
sexts125118382sexts
sifts84918922sifts
sits45050202sits
softs85019232softs
sots45552442sots
tats46858132tats
teats55636812teats
teffs115111732teffs
tents56434212tents
tests56530192tests
tets45847452tets
texts125515042texts
thefts12387922thefts
tits46145032tits
tofts84919242tofts
tots46654122tots
tufts85713272tufts
tuts45838452tuts
uts35534372_uts
vats76841742vats
vents86125932vents
verts85724732verts
vests85325982vests
vets76835092vets
wafts116920552wafts
wats77555882wats
weets85427722weets
weft105435012weft_
welts85225192welts
wests85727002wests
wets75940292wets
wits76044872wits
wots76342892wots
yetts86715132yetts
zests145419742zests
zits136030292zits

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.0762351197.4
2DLD Change Limit298722370.86034734.9
3Display Results2372370.0633761.9
 (SQL Overall)1786912370.999178869.9
 
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.