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

229 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
icelike133717(None) 
apelike13310532apelike
beelike13379782beelike
belike124616282_belike
eyelike1436972eyelike
hoelike141411162hoelike
inklike1037032inklike
ivylike1734282ivylike
kitelike1135732kitelike
lacelike1438492lacelike
lifelike15166222lifelike
linelike12159002linelike
pinelike14188612pinelike
pipelike16166692pipelike
tidelike1336742tidelike
tilelike1237052tilelike
toelike11149822toelike
viselike1536922viselike
wifelike18135252wifelike
wirelike15167492wirelike
aguelike1344673aguelike
airlike11310333airlike
alike95523963__alike
antlike11312073antlike
armlike1348553armlike
asslike1137373asslike
axlike17388853_axlike
baglike14338943baglike
batlike133311883batlike
bedlike14369533bedlike
beeline93314723beeline
belie75630383_beli_e
belive115415303_belive
biblike1536893biblike
birdlike1535233birdlike
bowlike16349473bowlike
boxlike20267073boxlike
bricklike1643113bricklike
budlike14257873budlike
cagelike1537723cagelike
catlike132712933catlike
cavelike1738213cavelike
celiac101910433_celiac
cellae84915933_cellae
cerise84822043_cerise
cerite84724873_cerite
cicelies1269753cicelies
cilice103213353_cilice
civetlike1842703civetlike
clime95720893_c_lime
cline76428533_c_line
cocklike1536733cocklike
cokelike1336813cokelike
cuplike1537213cuplike
decline103716613decline
deerlike1335723deerlike
delime9314043_delime
dirgelike1543213dirgelike
disclike15208653disclike
dishlike16287893dishlike
disklike12206743disklike
dislike122913453dislike
doglike13207453doglike
domelike15177753domelike
dovelike16157133dovelike
dunelike1335303dunelike
eellike1138233eellike
elflike1435133elflike
elide64922643__elide
elite56230183__elite
epiclike1644143epic_like
fadlike15318483fadlike
fanlike142610503fanlike
fatlike142911193fatlike
feline94820143_feline
fiberlike1844123fiberlike
filmlike1734443filmlike
finlike14279063finlike
fishlike18225873fishlike
foxlike21226223foxlike
fumelike1735223fumelike
fuselike1535673fuselike
gamelike1538033gamelike
gatelike1337933gatelike
gemlike14206813gemlike
glenlike1334043glenlike
gluelike1335023gluelike
godlike1387563godlike
gumlike14317403gumlike
gutlike12308653gutlike
harelike1539613harelike
hatlike143311713hatlike
henlike1448693henlike
hiplike1637603hiplike
hoblike16158303hoblike
hoglike15157733hoglike
homelike17179533homelike
hoselike15179643hoselike
hutlike14349063hutlike
iceblink1642183iceblink
iceblinks1741513iceblinks
iceless9219963iceless
icemaker1644443icemaker
ichnite1245983ichnite
idealise938053idealise
idealize1847873idealize
idolise839293idolise
idolize1737783idolize
illite63414923i_llite
incline9314643incline
iolite63221983i_olite
ironlike1235713ironlike
isoline7314013isoline
itemise997453itemise
itemize18106153itemize
jadelike2035993jadelike
jamlike20126923jamlike
jawlike21116003jawlike
jetlike18276763jetlike
jiglike19105333jiglike
jutelike1935333jutelike
kidlike1137063kidlike
kiltlike1134243kiltlike
kinglike1235093kinglike
knifelike1542263knifelike
lakelike1137383lakelike
lawlike14137073lawlike
leglike12136843leglike
lifeline11167663lifeline
like86040843___like
lilylike1543853lilylike
lionlike1234983lionlike
liplike1337283liplike
manlike133012783manlike
maplike15299273maplike
mazelike2336463mazelike
micellae1295723micellae
micelle1178343micel_le
mislike132914833mislike
myeline1238253myeline
necklike13104563necklike
netlike11308913netlike
niblike1336703niblike
noselike12158573noselike
nunlike11258073nunlike
nutlike113110113nutlike
oaklike10268003oaklike
oarlike113411193oarlike
oatlike113412403oatlike
obelise9310173obelise
obelize1838243obelize
ovenlike1535013ovenlike
owllike1435713owllike
oxlike17307473_oxlike
pealike131211273pealike
peglike14136773peglike
pelite84323003_pelite
picoline12310853picoline
piglike14157313piglike
pincerlike1843003pincerlike
pipeline12149503pipeline
podlike14108553podlike
poetlike1436733poetlike
popelike16177853popelike
potlike13910123potlike
prelife1279943prelife
puslike1347563puslike
ratlike113912353ratlike
raylike14269253raylike
recline94020493recline
reedlike1336213reedlike
reline65434353_reline
relive95120783_relive
riblike1337333riblike
ringlike1336243ringlike
riverlike1644483riverlike
rocklike1335903rocklike
rodlike1288263rodlike
ropelike14157853ropelike
roselike12169183roselike
ruglike1236283ruglike
runelike1236033runelike
sacklike1337303sacklike
saclike131210123saclike
sawlike14138443sawlike
scablike1635553scablike
scalelike1545253scalelike
screwlike1843303screwlike
scumlike1644353scumlike
seedlike1335993seedlike
selkie102811693_selkie
shedlike1635833shedlike
sideline91011093sideline
sighlike1635533sighlike
silklike1135523silklike
skylike1336103skylike
sonlike112110713sonlike
spikelike14103873spikelike
spinelike1585353spinelike
stemlike1436723stemlike
steplike1436733steplike
sticklike1444003sticklike
suchlike1735123suchlike
sunlike112310573sunlike
taglike12278913taglike
tapelike1437493tapelike
tealike111111083tealike
tigerlike1443533tigerlike
timeline1039243timeline
tinlike11248803tinlike
toylike14157243toylike
treelike1237003treelike
tubelike1436093tubelike
tublike1337083tublike
unalike11311533unalike
unlike102614063_unlike
urnlike1136713urnlike
vaselike1536993vaselike
warlike142410473warlike
wavelike1836613wavelike
waxlike21185973waxlike
weblike1635923weblike
weedlike1634393weedlike
wheylike2143403wheylike
wiglike15125853wiglike
winglike1635593winglike
wisplike1734713wisplike
witchlike2143103witchlike
zibeline1946363zibeline

Search took 7 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.406440125.6
2DLD Change Limit1340272296.34321129.9
3Display Results2292290.0932462.4
 (SQL Overall)1786912296.84226116.8
 
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.