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

228 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
hiker12511939(None) 
biker116022561biker
diker105524551diker
hider95024081hider
hike116830391hike_
hiked135919201hiked
hikers135014351hikers
hikes125426981hikes
hirer85423121hirer
liker95627061liker
piker115622841piker
siker95326031siker
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
asker96418782asker
baker115629542baker
bicker144819172bicker
bider85728372bider
bier65531832bi_er
bike106532602bike_
biked125320032biked
bikers124517552bikers
bikes117529472bikes
bilker124913442bilker
biner75930692biner
biter75030032biter
chicer134513602chicer
chider125116052chider
chimer135517202chimer
chirker16429322chirker
choker154314372choker
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
hacker154822692hacker
hailer94720342hailer
hake115637842hake_
hakes126034302hakes
haler85033522haler
hanker134622092hanker
hater85034752hater
haver115124462haver
hawker164812662hawker
hayer114620242hayer
hazer174820232hazer
heder95623642heder
heifer1238202heifer
her66547812h__er
hewer115719932hewer
hexer155116682hexer
hickey185011992hickey
hide85134642hide_
hided105222442hided
hiders104919652hiders
hides95129422hides
hie67652702hi_e_
hied85434042hi_ed
hies74842832hi_es
higher134610892higher
hilar85418142hilar
hiller94421632hiller
hinder104120062hinder
hinger104723332hinger
hinkier143610792hinkier
hinter94021302hinter
hipper133818022hipper
hire75538962hire_
hired95226262hired
hiree85427802hiree
hirers94518062hirers
hires86134342hires
hisser94713792hisser
hither124417252hither
hitter94419862hitter
hive106029672hive_
hived125217912hived
hives116925512hives
hocker155118562hocker
hoer76533982h_oer
hoke115935932hoke_
hoked135326992hoked
hokes126231642hokes
hokey155422182hokey
hokier134214032hokier
homer105828452homer
honer85332092honer
honker134117462honker
hooker134820172hooker
hoper105829142hoper
hoser811529762hoser
hover115524132hover
huger94914872huger
hunker133917672hunker
husker134212702husker
hyper135213902hyper
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
picker144422172picker
pier66035292pi_er
pike106335212pike_
piked125623312piked
pikers124717392pikers
pikes115031032pikes
pinker125322442pinker
piper96523192piper
poker115122882poker
raker94529792raker
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
risker105414492risker
river85731692river
saker95132022saker
shaker134319462shaker
shicker163914822shicker
shier85428942shi_er
shikar1336802shikar
shikker13277022shikker
shiner93820872shiner
shirker143711342shirker
shiver124517372shiver
sicker124023902sicker
sike87138782sike_
sikes96236082sikes
sinker103620902sinker
siver85728612siver
sizer145521812sizer
skier95119592skier
spiker124315662spiker
taker95229002taker
thicker163611022thicker
thinker143610682thinker
ticker124321502ticker
tier44936142ti_er
tiger65718632tiger
tike85534482tike_
tikes95628902tikes
tiler56131022tiler
timer75626042timer
tinker103619922tinker
titer55430612titer
toker95924912toker
vier75428152vi_er
viler86324162viler
viper105017302viper
waker125526592waker
whicker19359772whicker
whiner124516632whiner
whisker17367932whisker
whiter124316392whiter
wicker154518672wicker
wider94826352wider
winker134220292winker
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
yikes125117752yikes

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.313570897.8
2DLD Change Limit538002281.39038705.0
3Display Results2282280.0633619.0
 (SQL Overall)1786912281.766101184.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.