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

150 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
seely8452263(None) 
eely77725211_eely
seedy94821531seedy
seel45042981seel_
seels55632821seels
seemly1138431seemly
seepy104717971seepy
steely93612571steely
beefy135313832beefy
beery105220122beery
belly104625492belly
deedy104315892deedy
deeply1257012deeply
delly96023872delly
eel37946842_eel_
eels46536742_eels
eery76129622_eery
feebly1436652feebly
feel75233842feel_
feels85223042feels
felly114922802felly
ferly115517352ferly
feyly14429512feyly
freely12310952freely
geeky134710732geeky
heel75034222heel_
heels85625532heels
jelly154218252jelly
keel85729462keel_
keels94622412keels
keenly1336372keenly
kelly124617022kelly
leery85919132leery
mealy104422182mealy
meekly1535192meekly
meetly1138672meetly
merely111312582merely
needy94614692needy
nelly84618812nelly
newly114610202newly
peel65535612peel_
peels75226422peels
peery105719442peery
redly94217192redly
reedy910020282reedy
reefy114217702reefy
reeky125416262reeky
reel45240532reel_
reels55333262reels
refly113914562refly
rely75428952_rely
reply104015852reply
sadly94519122sadly
safely12249392safely
sagely102811382sagely
sally85129712sally
sanely93114612sanely
scaly104718722scaly
seal45654372seal_
seals54839692seals
seamy105921272seamy
sedgy104512782sedgy
see35772262see__
seed55549482see_d
seedily1178582seedily
seeds64330062seeds
seek85935482see_k
seeks94724642seeks
seeled73922092seeled
seem65438562see_m
seems75525022seems
seen46943122see_n
seep66540342see_p
seeps74828752seeps
seer45547042see_r
seers55136382seers
sees45361052see_s
sel38253322s_el_
self75138292s_elf
sell45840612s_ell
selle54428312selle
sells55134432sells
sels46345982s_els
sepoy10314302sepoy
serry84824122serry
sexily1638852sexily
sexy146418022s_exy
shaly114322862shaly
sheeny124912192sheeny
sheerly13337702sheerly
shelf115221112shelf
shell84424122shell
shelly124414462shelly
shelty124011542shelty
shelvy15377862shelvy
shily115222012shily
shyly144811572shyly
silly84527612silly
skell94915832skell
skelm114211282skelm
skelp114211422skelp
sleekly14325182sleekly
sleeky13398962sleeky
sleepy11479412sleepy
sleety94112652sleety
slily85820032slily
sly66228562s__ly
slyly11489532slyly
smell74916232smell
smelly114110352smelly
smelt74726782smelt
sneery93610412sneery
sneezy18345272sneezy
snell54517302snell
solely93714212solely
sonly85718052sonly
sorely94618002sorely
speedy1218410782speedy
speel74420762speel_
speels85116392speels
spell75020302spell
spelt75430192spelt
steel55721992steel_
steels64117982steels
steeply1236292steeply
stela54019042stela
stele55026842stele
stewy116112062stewy
stey76224412ste_y
suety85318492suety
sully84622892sully
surely93816452surely
surly85124422surly
sweeny12358842sweeny
sweepy14447452sweepy
sweetly1335592sweetly
swell84815982swell
teel46335802teel_
teels55726372teels
teeny85417882teeny
telly84920822telly
vealy115817772vealy
veery115816252veery
weedy125115002weedy
weekly1635312weekly
weel75834082weel_
weeny115316162weeny
weepy134212592weepy
welly114620012welly
wetly114511712wetly

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 Limit538001501.76330516.2
3Display Results1501500.0503000.0
 (SQL Overall)1786911501.90693751.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.