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

213 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
keels9462241(None) 
eels46536741_eels
feels85223041feels
heels85625531heels
keefs125116281keefs
keeks84717251keeks
keel85729461keel_
keens95721181keens
keeps116020281keeps
keets95123481keets
kevels134410711kevels
kneels10408931kneels
koels94613901koels
peels75226421peels
reels55333261reels
seels55632821seels
teels55726371teels
akees96119242akee_s
axels126313632axels
bedels94015272bedels
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382bee_s
beets76131442beets
bells76432162bells
bels66142492_bels
betels84515062betels
bevels113913982bevels
bezels173712282bezels
cees65941592cee_s
ceils75019402ceils
cells75428062cells
cels65534972_cels
creels84416942creels
deals65435342deals
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deers64930522deers
dees56356632dee_s
deets65330242deets
deils65722862deils
deles65139252deles
dells66630942dells
dels56745472_dels
devels104313902devels
duels65619232duels
eel37946842_eel_
eely77725212_eely
ekes86726602eke_s
ells46431352_ells
els37645722__els
feebs106112682feebs
feeds94921142feeds
feel75233842feel_
fees76450602fee_s
fells85327382fells
fuels87117352fuels
geeks104915842geeks
gees55647882gee_s
gels56836102_gels
heals85733452heals
heeds95420422heeds
heel75034222heel_
heils85222192heils
hells85032042hells
herls85226432herls
jebels15418912jebels
jeeps144715372jeeps
jeers124818132jeers
jees115938542jee_s
jells125522162jells
jewels16508612jewels
kaes85734062kae_s
kails95525212kails
kales95730982kales
keas86337092k_eas
kecks105416572kecks
keef115829992kee_f
keek75624962kee_k
keeled114414262keeled
keelson1153992keelson
keen84830402kee_n
keenly1336372keenly
keep106329812kee_p
keet85347332kee_t
keeve124512122keeve
keeves133711982keeves
kefs115922742k_efs
kegs95824012k_egs
keirs95313672keirs
kelep116014552kelep
keleps12478812keleps
kelly124617022kelly
kelp105322802k_elp
kelps115116422kelps
kelt85343192k_elt
kelts95222632kelts
kemps135012522kemps
kennels11387192kennels
kenos95220622kenos
kens85435232k_ens
kepis115313362kepis
keps106027302k_eps
kerbs115013672kerbs
kerfs125413572kerfs
kernels11417952kernels
kerns94719562kerns
ketols104210762ketols
kevel124213092kevel_
kevils13358332kevils
kexes166216812kexes
keys116322162k_eys
khets124913432khets
kiefs126112202kiefs
kiers95320092kiers
kills94526172kills
kneel95012032kneel_
knees95114872knees
knell94210922knell
knells10439252knells
knelt94617682knelt
koel84519942koel_
kohls12437802kohls
kreeps12427412kreeps
kues86426772kue_s
kugels1146072kugels
kvell12436692kvell
kvells13346612kvells
kyes115124932kye_s
leeks95318892leeks
leers54828982leers
lees45455882lee_s
leets54927122leets
levels94113282levels
meals75933372meals
meeds84920272meeds
meets74224612meets
mells75031332mells
mels65941532_mels
merls77423902merls
mewls105813232mewls
needs65719632needs
neems77316292neems
neeps75617882neeps
newels93710822newels
noels56418702noels
peals75235492peals
peeks115021112peeks
peel65535612peel_
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372pee_s
peles75738082peles
reals55038652reals
rebels84518132rebels
reeds65430902reeds
reefs85121662reefs
reeks94124032reeks
reel45240532reel_
rees45364192ree_s
refels94618052refels
repels84318762repels
revels94220572revels
riels55121332riels
seals54839692seals
seeds64330062seeds
seeks94724642seeks
seel45042982seel_
seely84522632seely
seems75525022seems
seeps74828752seeps
seers55136382seers
sees45361052see_s
sells55134432sells
sels46345982_sels
skeens103912912skeens
skees95023122skee_s
skeets104513252skeets
skells105013782skells
speels85116392speels
steels64117982steels
taels56822072taels
teals56234132teals
teel46335802teel_
teems76019782teems
teens56227482teens
tees45353582tee_s
teles54536002teles
tells55828942tells
tels46841692_tels
vakeels14113732vakeels
veals84926192veals
veeps104715722veeps
veers84521362veers
vees75439432vee_s
veils84918802veils
weals85428742weals
wedels103811032wedels
weeds95222212weeds
weeks125017862weeks
weel75834082weel_
weens85224052weens
weeps104120562weeps
wees76249122wee_s
weets85427722weets
wells85426192wells
wheels123811712wheels
yells85821942yells
zeals145320852zeals
zees136331892zee_s

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.0931921408.6
2DLD Change Limit538002131.39038705.0
3Display Results2132130.0633381.0
 (SQL Overall)1786912131.546115582.8
 
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.