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

239 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
eider6462474(None) 
aider65431131aider
bider85728371bider
cider84723311cider
eide55832231eide_
eiders74321361eiders
elder64020021elder
ender64325861ender
hider95024081hider
rider65231301rider
wider94826351wider
abider95314462abider
adder75419592adder
aide56044992aide_
aided75828932aided
aiders74524632aiders
aides65336602aides
aimer75926822aimer
airer54927892airer
aiver85725162aiver
alder65421912alder
arider74717742arider
beader94623792beader
bedder104215782bedder
bender95223302bender
bidder104114862bidder
bide76041472bide_
bided95424962bided
biders94822802biders
bides85536772bides
bidet84935622bidet
bier65531822bi_er
biker116022562biker
binder94422872binder
biner75930692biner
birder94915492birder
biter75030032biter
ceder85322232ceder
ceiler84013962ceiler
chider125116052chider
ciders94620082ciders
cinder94119122cinder
citer74827322citer
coder86134212coder
cyder114611132cyder
deader84220472deader
decider114213182decider
deicer94114412deicer
derider93214972derider
dicer85426422dicer
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
diver94827802diver
eager65526962eager
eater54639842eater
edger75215932edger
eger55923562e_ger
egger74414402egger
eidos65817752eidos
either94517422either
elders74817302elders
elide64922642elide_
elided84814672elided
elides74420692elides
eluder73712212eluder
elver85216242elver
ember95516792ember
emeer74815362emeer
emmer94314462emmer
endear74110012endear
ended74421262ended
enders74324052enders
enter54726382enter
epiderm1236192epiderm
epimer10109152epimer
esker94412982esker
ester54727712ester
ether84518772ether
evader1036812evader
ever77027692e_ver
eviler94811892eviler
ewer77523982e_wer
exiler134712182exiler
eyer76127282e_yer
fader94421512fader
feeder103513842feeder
fender103718722fender
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finder104020232finder
finer85431562finer
firer811229252firer
fiver116024942fiver
fixer154717832fixer
gelder84613712gelder
gender83517932gender
giber85417702giber
gilder84415532gilder
girder84312062girder
giver94921202giver
glider84614262glider
guider84313522guider
header104422542header
heder95623632heder
heeder104216042heeder
heifer1238202heifer
herder104516462herder
hide85134622hide_
hided105222442hided
hiders104919652hiders
hides95129422hides
hiker125119392hiker
hinder104120062hinder
hirer85423122hirer
idea59122772_idea
idem76121062_idem
ides57734232_ides
idler65015662_idler
jiber145115702jiber
jiver155119052jiver
kidder123811092kidder
kier86526802ki_er
kinder113716842kinder
kiter95523212kiter
lader65633722lader
leader74824652leader
lender73921272lender
lewder10479612lewder
liber74723612liber
lidar6312722lidar
lieder74912322lieder
lier45942462li_er
lifer85822152lifer
liger65024462liger
liker95627062liker
liner55938912liner
liter54736342liter
liver85132962liver
melder93915812melder
mender93520792mender
milder93818452milder
miler75733062miler
mimer94825762mimer
minder94822502minder
miner76933542miner
miser75430402miser
miter75734792miter
mixer145017642mixer
needer73614952needer
nicer74618292nicer
nide55535782nide_
nided75920872nided
nides65229132nides
niter55028972niter
nuder66416832nuder
odder74515392odder
oiler54628282oiler
older65121172older
order65019362order
pier66035292pi_er
piker115622842piker
pinder94523452pinder
piper96523192piper
raider74318742raider
reader73628292reader
redder83918132redder
reiver95318292reiver
render74024142render
resider84615802resider
ricer74726612ricer
ridder84015142ridder
ride55945122ride_
riders74123902riders
rides66140812rides
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
ruder65320542ruder
seder64826752seder
seeder74320772seeder
seidel7311082seidel
seiner64622482seiner
seiser65318342seiser
seizer154114572seizer
sender73824412sender
side55444482side_
sided74825952sided
sides65838362sides
sidler74716962sidler
siker95326032siker
siver85728612siver
sizer145521812sizer
slider73918362slider
snider74413912snider
spider94516802spider
tedder83312152tedder
tender74121842tender
tide55237372tide_
tided76322512tided
tides64830152tides
tidier73515112tidier
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tinder73821802tinder
titer55430612titer
udder76314282udder
under64624212under
veiler93814352veiler
veiner94514752veiner
vender103418422vender
vide85432752vide_
video96014952video
vier75428152vi_er
viler86324162viler
viper105017302viper
voider103611552voider
wader95325362wader
wedder113612292wedder
weeder103315512weeder
weiner94214132weiner
weirder1144922weirder
welder102914412welder
widder112913972widder
wide85235402wide_
widen94717972widen
wides94832822wides
wilder103616472wilder
winder104025262winder
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver

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.1731032896.0
2DLD Change Limit538002391.89028465.6
3Display Results2392390.0763144.7
 (SQL Overall)1786912392.13983539.5
 
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.