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 “ivylike” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

154 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
ivylike173428(None) 
icelike1337172icelike
inklike1037032inklike
ivorylike1941422ivorylike
lilylike1543852lilylike
raylike14269252raylike
skylike1336102skylike
toylike14157242toylike
airlike11310333airlike
alike95523963__alike
antlike11312073antlike
apelike13310533apelike
armlike1348553armlike
asslike1137373asslike
axlike17388853_axlike
baglike14338943baglike
batlike133311883batlike
bedlike14369533bedlike
beelike13379783beelike
belike124616283_belike
beylik1545883beylik_
beyliks1634853beyliks
biblike1536893biblike
birdlike1535233birdlike
bowlike16349473bowlike
boxlike20267073boxlike
budlike14257873budlike
byline11311643_byline
catlike132712933catlike
cavelike1738213cavelike
civetlike1842703civetlike
civilise1386263civilise
civilize22106393civilize
claylike1734463claylike
cuplike1537213cuplike
disclike15208653disclike
dishlike16287893dishlike
disklike12206743disklike
dislike122913453dislike
doglike13207453doglike
dovelike16157133dovelike
eellike1138233eellike
elflike1435133elflike
eyelike1436973eyelike
fadlike15318483fadlike
fairylike1942693fairylike
fanlike142610503fanlike
fatlike142911193fatlike
filmlike1734443filmlike
finlike14279063finlike
fishlike18225873fishlike
foxlike21226223foxlike
gemlike14206813gemlike
godlike1387563godlike
gumlike14317403gumlike
gutlike12308653gutlike
guyline11258173guyline
hatlike143311713hatlike
henlike1448693henlike
hiplike1637603hiplike
hoblike16158303hoblike
hoelike141411163hoelike
hoglike15157733hoglike
hutlike14349063hutlike
idolise839293idolise
idolize1737783idolize
idylist1146653idylist
illite63414923i_llite
incline9314643incline
iolite63221983i_olite
ironlike1235713ironlike
isoline7314013isoline
jamlike20126923jamlike
jawlike21116003jawlike
jetlike18276763jetlike
jiglike19105333jiglike
kidlike1137063kidlike
kiltlike1134243kiltlike
kinglike1235093kinglike
kitelike1135733kitelike
kylikes1333583_kylikes
ladylike1634683ladylike
lavalike1536283lavalike
lawlike14137073lawlike
leglike12136843leglike
lifelike15166223lifelike
like86040843___like
linelike12159003linelike
lionlike1234983lionlike
liplike1337283liplike
manlike133012783manlike
maplike15299273maplike
mislike132914833mislike
netlike11308913netlike
niblike1336703niblike
novalike1536223novalike
nunlike11258073nunlike
nutlike113110113nutlike
oaklike10268003oaklike
oarlike113411193oarlike
oatlike113412403oatlike
ovenlike1535013ovenlike
owllike1435713owllike
oxlike17307473_oxlike
pealike131211273pealike
peglike14136773peglike
piglike14157313piglike
pinelike14188613pinelike
pipelike16166693pipelike
playlike1735613playlike
podlike14108553podlike
potlike13910123potlike
puslike1347563puslike
quaylike2434143quaylike
ratlike113912353ratlike
riblike1337333riblike
ringlike1336243ringlike
riverlike1644483riverlike
rodlike1288263rodlike
rubylike1753353rubylike
ruglike1236283ruglike
saclike131210123saclike
sawlike14138443sawlike
sighlike1635533sighlike
silklike1135523silklike
skyline1436793skyline
sonlike112110713sonlike
stylise10208953stylise
stylite10219613stylite
stylize19177453stylize
sunlike112310573sunlike
taglike12278913taglike
tealike111111083tealike
tidelike1336743tidelike
tilelike1237053tilelike
tinlike11248803tinlike
toelike11149823toelike
tublike1337083tublike
unalike11311533unalike
unlike102614063_unlike
urnlike1136713urnlike
valine94623093_valine
valise92917643_valise
viselike1536923viselike
warlike142410473warlike
wavelike1836613wavelike
waxlike21185973waxlike
weblike1635923weblike
wheylike2143403wheylike
wifelike18135253wifelike
wiglike15125853wiglike
winglike1635593winglike
wirelike15167493wirelike
wisplike1734713wisplike

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271546.64320175.7
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.09625181.9
 
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.