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

341 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
likes9623190(None) 
bikes117529471bikes
dikes105831331dikes
hikes125426981hikes
kikes85122551kikes
lakes95737651lakes
lies46454191li_es
like86040841like_
liked104523811liked
liken911818841liken
likens105613701likens
liker95627061liker
likers104620911likers
likest104914381likest
limes75636501limes
lines57054571lines
lives86133191lives
mikes115129891mikes
pikes115031031pikes
sikes96236081sikes
tikes95628901tikes
yikes125117751yikes
aides65336602aides
alike95523962alike_
alines65735222alines
alkies104518092alkies
alsikes1137262alsikes
bakes117035372bakes
bices95029962bices
bides85536772bides
bike106532592bike_
biked125320032biked
biker116022562biker
bikers124517552bikers
bikies124515162bikies
biles75542142biles
bines76946792bines
bises75435622bises
bites75641172bites
bizes165923662bizes
blites84721212blites
blokes123813882blokes
cakes116037672cakes
cines75239682cines
cires74932912cires
cites74435582cites
climes104720002climes
clines84926042clines
cokes115537192cokes
cukes115422092cukes
dekes105224452dekes
dices86434242dices
dies55653522di_es
dike95935762dike_
diked115024682diked
diker105524552diker
dikers114418792dikers
dikey135116422dikey
dimes85833042dimes
dines66449152dines
dites66339152dites
dives95832402dives
dukes105023472dukes
dykes135215572dykes
ekes86726602_ekes
elides74420692elides
elites66027122elites
fakes126032482fakes
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
flakes134118872flakes
flies85630712fli_es
flites95122442flites
flukes135114192flukes
fykes156312692fykes
gibes84422522gibes
gies55641422gi_es
gites65630182gites
gives95324872gives
glides84518862glides
glimes94717522glimes
hakes126034302hakes
hides95129422hides
hies74842832hi_es
hike116830392hike_
hiked135919202hiked
hiker125119392hiker
hikers135014352hikers
hires86134342hires
hives116925512hives
hokes126231642hokes
ices66129642_ices
ides57734232_ides
ilks87218572ilk_s
ires45639282_ires
jakes165023642jakes
jibes145520322jibes
jives154820812jives
jokes165423332jokes
jukes165319102jukes
kibes115521112kibes
kike76524782kike_
kines95039132kines
kites95432542kites
kliks8398822klik_s
kylikes1333582kylikes
laces76141762laces
lades65141272lades
lake85741602lake_
laked105731122laked
laker95432872laker
lakers105225152lakers
lakhs125210342lakhs
lames75445542lames
lanes54946792lanes
lares54852632lares
lases54944762lases
latkes104715872latkes
laves86039152laves
laxes125430092laxes
lazes145129572lazes
leeks95318892leeks
lees45455882l_ees
leges64427282leges
leke85527402leke_
leks85427602lek_s
lenes54738522lenes
les35663072l__es
leses54930812leses
lexes127225262lexes
lianes63819322lianes
liars54723162liars
libel74116102libel
libels85112692libels
liber74723612liber
libers84721432libers
libs66732752li_bs
lice66045062lice_
liches114724292liches
licked134621562licked
licker125222042licker
lickers134118252lickers
licks115325392licks
lidos65219882lidos
lids56336452li_ds
lie38264522li_e_
lied55838092li_ed
lief76036982li_ef
lieges74113442lieges
lien45339802li_en
liens56525502liens
lier45942462li_er
liers55130402liers
lieu46534362li_eu
lieus56218482lieus
life75433732life_
lifer85822152lifer
lifers95617842lifers
lifts85719062lifts
liger65024462liger
ligers75022022ligers
likely13328132likely
lilies63021412lilies
lilos55821872lilos
lilts55822802lilts
limas75627632limas
limbs96118932limbs
lime66244932lime_
limed85426802limed
limen75426032limen
limens84618032limens
limey104721042limey
limeys11429272limeys
limns75718392limns
limos75320812limos
limps95522672limps
line46965572line_
lined64934642lined
linen55728722linen
linens64818392linens
liner55938912liner
liners65428842liners
liney87029622liney
lings67135772lings
linked114518212linked
linker104321462linker
linkers114317702linkers
links96430192links
linns56123332linns
linos55631502linos
lins47059052li_ns
lints57137192lints
lions55923212lions
lipe66839732lipe_
lips67141442li_ps
liras56021982liras
lire47845292lire_
lis37162272li__s
lisles63416282lisles
lisps76913902lisps
lists56628692lists
litas54923772litas
lite47054542lite_
liter54736342liter
liters65429872liters
litres65220392litres
lits46252492li_ts
live76540992live_
lived95523722lived
liven85021732liven
livens94314892livens
liver85132962liver
livers94927822livers
livest95315732livest
livres94311862livres
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lopes76437342lopes
lores55045402lores
loses56742012loses
loves85332012loves
lowes85732462lowes
loxes125227472loxes
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552l_ues
luges65928752luges
lunes55337772lunes
lures56138532lures
lutes55836662lutes
luxes124921502luxes
lyes75530832l_yes
lyres85019962lyres
lyses84518252lyses
makes115336852makes
mike105535282mike_
miked125020452miked
miles74645072miles
mimes95732022mimes
mines75651952mines
minkes124618782minkes
mires75640882mires
mises74740562mises
mites75141802mites
mixes147224402mixes
mokes114631032mokes
nides65229132nides
nines55937342nines
nites55736342nites
nixes124519622nixes
nukes95418122nukes
okes84936342_okes
olives94313952olives
pekes114623562pekes
pies66949602pi_es
pikas114218092pikas
pike106335212pike_
piked125623312piked
piker115622842piker
pikers124717392pikers
pikis115116392pikis
piles74742612piles
pines76048862pines
pipes96030142pipes
pixes144323172pixes
plies74526512pli_es
pokes116133012pokes
pukes114523022pukes
rakes94440352rakes
ribes75530172ribes
rices75536152rices
rides66140812rides
riles55343642riles
rimes75634542rimes
ripes75435772ripes
rises55244042rises
rites54442552rites
rives85336002rives
rykes125513032rykes
sakes95540752sakes
sices75637272sices
sides65838362sides
sikas94617022sikas
sike87138782sike_
siker95326032siker
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
skies95026832skies
slakes104021882slakes
slices84022852slices
slides73922182slides
slimes84722042slimes
slipes84921412slipes
sokes95031422sokes
spikes124520712spikes
sykes124816862sykes
takes94437792takes
tides64830152tides
ties45248312ti_es
tike85534482tike_
tikis95615972tikis
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
tokes95234972tokes
trikes105419492trikes
tykes125817062tykes
ukes86122812_ukes
vibes104719952vibes
vices105725532vices
vies75238622vi_es
vines85137642vines
vires84529682vires
vises84427772vises
wakes126633652wakes
wides94832822wides
wifes114522562wifes
wiles85437872wiles
wines85546862wines
wipes104827082wipes
wires86034912wires
wises85633192wises
wites85536962wites
wives115328922wives
wizes174723342wizes
yipes106017842yipes
yokes125223022yokes
zines145232652zines

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.0931921408.6
2DLD Change Limit538003411.79629955.5
3Display Results3413410.0963552.1
 (SQL Overall)1786913411.98590020.7
 
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.