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

296 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
siker9532603(None) 
biker116022561biker
diker105524551diker
hiker125119391hiker
liker95627061liker
piker115622841piker
saker95132021saker
sicker124023901sicker
sike87138781sike_
sikes96236081sikes
sinker103620901sinker
siver85728611siver
sizer145521811sizer
skier95119591skier
spiker124315661spiker
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
asker96418782asker
baker115629542baker
bicker144819172bicker
bider85728372bider
bier65531832bi_er
bike106532602bike_
biked125320032biked
bikers124517552bikers
bikes117529472bikes
bilker124913442bilker
biner75930692biner
biter75030032biter
cider84723312cider
citer74827332citer
daiker115113032daiker
dicer85426422dicer
dicker134521402dicker
dike95935762dike_
diked115024682diked
dikers114418792dikers
dikes105831332dikes
dikey135116422dikey
dimer85625602dimer
diner65632902diner
direr64927072direr
diver94827802diver
duiker114110592duiker
eider64624742eider
esker94412982esker
faker124824592faker
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finer85431562finer
firer811229252firer
fiver116024942fiver
fixer154717832fixer
giber85417702giber
giver94921202giver
hider95024082hider
hike116830392hike_
hiked135919202hiked
hikers135014352hikers
hikes125426982hikes
hirer85423122hirer
icker114018442icker
inker94421092inker
jiber145115702jiber
jinker174013542jinker
jiver155119052jiver
joker165715892joker
kicker114116182kicker
kier86526812ki_er
kike76524792kike_
kikes85122552kikes
kiter95523212kiter
laker95432872laker
liber74723622liber
licker125222042licker
lier45942462li_er
lifer85822152lifer
liger65024472liger
like86040842like_
liked104523812liked
liken911818842liken
likers104620912likers
likes96231902likes
liner55938922liner
linker104321472linker
liter54736342liter
liver85132962liver
maker114127812maker
mike105535292mike_
miked125020452miked
mikes115129892mikes
miler75733062miler
milker124814322milker
mimer94825762mimer
miner76933542miner
mirker123712692mirker
miser75430402miser
miter75734792miter
mixer145017642mixer
nicer74618292nicer
nicker123818702nicker
niter55028972niter
ocker113915752ocker
oiler54628282oiler
osier53518012osi_er
picker144422172picker
pier66035292pi_er
pike106335212pike_
piked125623312piked
pikers124717392pikers
pikes115031032pikes
pinker125322442pinker
piper96523192piper
poker115122882poker
raker94529792raker
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
risker105414492risker
river85731692river
saber75330242saber
sacker125124842sacker
safer84721812safer
sager65432052sager
sailer63526102sailer
sake85244962sake_
sakers104125432sakers
sakes95540752sakes
saner54334322saner
saver84831252saver
sawer85026212sawer
sayer84926552sayer
seder64826762seder
seeker103615362seeker
seer45547042s_eer
seiner64622482seiner
seiser65318342seiser
seizer154114572seizer
ser36752402s__er
serer55935512serer
sever85426052sever
sewer84426222sewer
shaker134319462shaker
sheer84726892sheer
shicker163914822shicker
shier85428942shier
shikar1336802shikar
shikker13277022shikker
shiner93820872shiner
shirker143711342shirker
shiver124517372shiver
shoer84722162shoer
shyer114714782shyer
sice65545592sice_
sices75637272sices
sicked134524402sicked
sickee124622222sickee
sicken124615252sicken
side55444492side_
sided74825952sided
sides65838362sides
sidler74716962sidler
sieur5911892sieur
sifter94516232sifter
sigher103813702sigher
signer74015632signer
sika86021322sik_a
sikas94617022sikas
silex123417412silex
silked114314812silked
silken104410852silken
silkier114411642silkier
siller64026062siller
silver93815812silver
simar74920812simar
simmer104115352simmer
simper103616292simper
sine46560622sine_
sines55954822sines
sinew84718922sinew
singer74227312singer
sinkers113618542sinkers
sinner64320602sinner
sinter63625922sinter
sipe67341042sipe_
siped84927682siped
sipes76036952sipes
sipper103920992sipper
sir35746672si__r
sire46150412sire_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
sises55233832sises
sister64421582sister
sitar54820542sitar
site47052412site_
sited65130742sited
sites56045432sites
sitter63323382sitter
sivers95324152sivers
sixes124526362sixes
sizar145214992sizar
size135630962size_
sized155519242sized
sizers155215812sizers
sizes146727762sizes
sizier1514813392sizier
skee85431472s_kee
skeg95316162s_keg
skep105219352s_kep
skew116218762s_kew
skied104417752skied
skiers104713702skiers
skies95026832skies
skiey125012892skiey
skinker10319442skinker
skirr94810542skirr
skiver134612102skiver
slaker104219272slaker
slicer84117602slicer
slicker133314532slicker
slider73918362slider
slier54827242slier
sliver94116592sliver
slyer85515122slyer
smiler83916682smiler
smirker13327422smirker
smiter83616412smiter
smoker124311692smoker
sneer54919952sneer
snicker133012672snicker
snider74413912snider
sniper84413642sniper
soaker105717532soaker
sober74822412sober
soke85436262soke_
sokes95031422sokes
sorer56236592sorer
sower85229312sower
speer74623902speer
spicer104719312spicer
spider94516802spider
spier75728032spier
spike114922842spike_
spiked134915552spiked
spikers135311992spikers
spikes124520712spikes
spikey155411332spikey
spikier13369982spikier
steer55423862steer
sticker133515882sticker
stinker113313312stinker
stiver93915732stiver
stoker104417622stoker
striker113714172striker
suber74924502suber
sucker124120662sucker
suer45334032s_uer
suiter64121812suiter
sulker104015922sulker
super74924482super
surer54833102surer
sweer84918572sweer
syke115420562syke_
sykes124816862sykes
taker95229002taker
ticker124321502ticker
tier44936142ti_er
tiger65718632tiger
tike85534482tike_
tikes95628902tikes
tiler56131022tiler
timer75626042timer
tinker103619922tinker
titer55430612titer
toker95924912toker
vier75428152vi_er
viler86324162viler
viper105017302viper
waker125526592waker
wicker154518672wicker
wider94826352wider
winker134220292winker
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
yikes125117752yikes

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.513348325.5
2DLD Change Limit538002961.70631535.8
3Display Results2962960.0763894.7
 (SQL Overall)1786912962.29577861.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.