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

293 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
deets6533024(None) 
beets76131441beets
debts86418371debts
deeds75423761deeds
deems85421771deems
deeps84921771deeps
deers64930521deers
dees56356631dee_s
deet57356581deet_
delts65731791delts
dents65031801dents
diets66026641diets
duets65323881duets
keets95123481keets
leets54927121leets
meets74224611meets
weets85427721weets
abets75621672abets
adeems946332adeems
adepts9117102adepts
beats76042242beats
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382bee_s
beet66457542beet_
begets96215522begets
belts75931162belts
bents76033692bents
berets85822522berets
besets85718802besets
bests75932612bests
bets67051442_bets
blets75324942blets
cees65941592cee_s
celts75325782celts
cents74730332cents
cetes75731102cetes
darts67635732darts
dates65639152dates
dauts67822242dauts
dawts97216122dawts
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
death94822522death
deaths105914442deaths
debits94214492debits
debs76530242d_ebs
debt77139022debt_
debuts93911752debuts
deceits102810882deceits
decks124822192decks
decos85522122decos
dee47665822dee__
deed65340902dee_d
deedy104315892deedy
deem75432892dee_m
deep76031882dee_p
deer56739022dee_r
defats105114552defats
defeats113511232defeats
defects134511522defects
defers105116942defers
defis96717502defis
deft85540222deft_
degas75119162degas
deils65722862deils
deist64633592deist
deists74916432deists
deity94316772deity
dejects17389222dejects
dekes105224452dekes
deles65139252deles
delete73620702delete
deletes83117932deletes
delfs94918672delfs
delfts10439672delfts
delis64928542delis
dells66630942dells
dels56745472d_els
delt57855272delt_
delta66117772delta
deltas74414822deltas
dements103016622dements
demes86032692demes
demits94918072demits
demos86022992demos
denes65639722denes
dens55945072d_ens
dent57158412dent_
depots94716342depots
depth114311852depth
depths12428572depths
derats74625062derats
derms85022892derms
deserts82513052deserts
desks105913072desks
detects104011092detects
detents83615152detents
deter65028042deter
deters74724682deters
detest74122842detest
detests83711742detests
devas96218882devas
devels104313902devels
devest104418702devest
devests114410472devests
devs86424032d_evs
dews86230602d_ews
dexes135224512dexes
deys85027472d_eys
dies55653522die_s
diet57357532diet_
dints67431312dints
dirts66824462dirts
dites66339152dites
dits56450522d_its
doats65224882doats
doers65225712doers
does56554472doe_s
doest65829522doest
doeth9411982doeth
doits66223672doits
dolts65626312dolts
dotes65836692dotes
dots55647662d_ots
drats66628372drats
drees65628522drees
dregs76114862dregs
dreks105714742dreks
dress65319832dress
drest65530342drest
ducts85319892ducts
duels65619232duels
dues56045502due_s
duet56446262duet_
duits65021882duits
dunts65828412dunts
dusts65923562dusts
duvets1039222duvets
dweebs1233652dweebs
dyers96617132dyers
dyes85331892dye_s
eats47054872_eats
edits65819032edits
eels46536742_eels
efts76519482_efts
feats86432752feats
feebs106112682feebs
feeds94921142feeds
feels85223042feels
fees76450602fee_s
feet75352212feet_
felts85324542felts
fests85828042fests
fetes85630142fetes
fets75345942_fets
fleets96915062fleets
frets85523402frets
geeks104915842geeks
gees55647882gee_s
geest64829612geest
geests75912162geests
gelts65924612gelts
genets75716662genets
gents65729612gents
gests66028812gests
gets55442482_gets
gleets75315052gleets
greets75117422greets
haets86525122haets
heats85838402heats
heeds95420422heeds
heels85625532heels
hefts116218152hefts
hents87330742hents
hests85829932hests
hets75547202_hets
jeeps144715372jeeps
jeers124818132jeers
jees115938542jee_s
jests125922452jests
jetes124922842jetes
jets115834102_jets
keefs125116282keefs
keeks84717252keeks
keels94622412keels
keens95721182keens
keeps116020282keeps
keet85347332keet_
kelts95222632kelts
khets124913432khets
leeks95318892leeks
leers54828982leers
lees45455882lee_s
leet45957902leet_
lefts86517812lefts
lets47147942_lets
meats75034052meats
meeds84920272meeds
meet65350552meet_
melts74930102melts
metes74736212metes
neats55931902neats
needs65719632needs
neems77316292neems
neeps75617882neeps
nerts55924982nerts
nests55728002nests
nets45941532_nets
netts55320722netts
newts86015282newts
peats76140192peats
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372pee_s
pelts76128812pelts
pests75933272pests
pets66248332_pets
poets76024442poets
reeds65430902reeds
reefs85121662reefs
reeks94124032reeks
reels55333262reels
rees45364192ree_s
reest54938092reest
reests64618892reests
relets64025672relets
rents55935182rents
resets65427612resets
rests54935872rests
rets45352562_rets
revets94022172revets
rewets94617212rewets
seats54844342seats
sects75622892sects
seeds64330062seeds
seeks94724642seeks
seels55632822seels
seems75525022seems
seeps74828752seeps
seers55136382seers
sees45361052see_s
septs75420602septs
sets45549502_sets
setts55124322setts
sexts125118382sexts
sheets93918492sheets
skeets104513252skeets
sleets64318872sleets
stets55423912stets
suets55126102suets
sweets94214432sweets
teats55636812teats
teels55726372teels
teems76019782teems
teens56227482teens
tees45353582tee_s
teeth87315852teeth
tenets65518952tenets
tents56434212tents
tests56530192tests
tets45847452_tets
texts125515042texts
trets55928022trets
tweets94210102tweets
veeps104715722veeps
veers84521362veers
vees75439432vee_s
vents86125932vents
verts85724732verts
vests85325982vests
vets76835092_vets
weeds95222212weeds
weeks125017862weeks
weens85224052weens
weeps104120562weeps
wees76249122wee_s
weest85026772weest
weet75254152weet_
wefts116715492wefts
welts85225192welts
wests85727002wests
wets75940292_wets
whets115019612whets
yetts86715132yetts
zees136331892zee_s
zests145419742zests

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.0931921408.6
2DLD Change Limit538002931.84329191.5
3Display Results2932930.0803662.5
 (SQL Overall)1786912932.01688636.4
 
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.