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

349 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
ratlike11391235(None) 
batlike133311881batlike
catlike132712931catlike
fatlike142911191fatlike
hatlike143311711hatlike
oatlike113412401oatlike
ratline74517801ratline
raylike14269251raylike
alike95523962_a_like
antlike11312072antlike
armlike1348552armlike
axlike17388852_axlike
baglike14338942baglike
boatlike1457962boatlike
crablike1636022crablike
fadlike15318482fadlike
fanlike142610502fanlike
gatelike1337932gatelike
gnatlike1334742gnatlike
goatlike1346292goatlike
gutlike12308652gutlike
hutlike14349062hutlike
jamlike20126922jamlike
jawlike21116002jawlike
jetlike18276762jetlike
lawlike14137072lawlike
manlike133012782manlike
maplike15299272maplike
mastlike1437862mastlike
moatlike1446992moatlike
netlike11308912netlike
nutlike113110112nutlike
oaklike10268002oaklike
oarlike113411192oarlike
potlike13910122potlike
ralline73518412ralline
rampike1536602rampike
ranpike1335932ranpike
rashlike1535792rashlike
ratine65131822rat_ine
ratite65022422rat_ite
ratlin64116522ratli_n
ratlines83815292ratlines
ratlins73615582ratlins
riblike1337332riblike
rodlike1288262rodlike
rootlike1236612rootlike
ruglike1236282ruglike
saclike131210122saclike
saltlike1237252saltlike
sawlike14138442sawlike
taglike12278912taglike
traplike1437652traplike
warlike142410472warlike
wartlike1537042wartlike
waxlike21185972waxlike
airlike11310333airlike
aline57243153_a_line
alive85722513_a_live
alkie95520033_a_lkie
alsike1047913_alsike
apelike13310533apelike
aplite8316393_aplite
asslike1137373asslike
attire62412383_attire
auntlike1234983auntlike
bailie83818363baili_e
balmlike1655353balmlike
barnlike1437183barnlike
batik11614733bat_ik_
batiked1435963bat_iked
batiks1239373bat_iks
battik1238093battik_
battiks1337143battiks
beadlike15137253beadlike
beaklike13155773beaklike
beamlike16115843beamlike
beanlike14146843beanlike
bearlike14156793bearlike
bedlike14369533bedlike
beelike13379783beelike
belike124616283_belike
biblike1536893biblike
boltlike1436313boltlike
bowlike16349473bowlike
boxlike20267073boxlike
brattice1245693brattice
brawlie12198153brawli_e
budlike14257873budlike
cagelike1537723cagelike
calflike1735153calflike
carline93923613carline
catlin83819083catli_n
catling104819793catling
catlins93818843catlins
cattie85221023catti_e
cauline92215603cauline
cavelike1738213cavelike
clamlike1635163clamlike
clawlike1733913clawlike
claylike1734463claylike
crapelike1744933crapelike
craterlike1644013craterlike
cultlike1434933cultlike
cuplike1537213cuplike
cutline92914543cutline
dateline9810353dateline
dative10311813dat_ive
dawnlike1634673dawnlike
deathlike1753823deathlike
dislike122913453dislike
doglike13207453doglike
dragline1036843dragline
dreamlike1642753dreamlike
drumlike1543793drumlike
dustlike1335363dustlike
earthlike1644623earthlike
eellike1138233eellike
elflike1435133elflike
eyelike1436973eyelike
fanglike1636823fanglike
fatling113815683fatling
faunlike1534763faunlike
fawnlike1844143fawnlike
feltlike1534983feltlike
finlike14279063finlike
flatline11298923flatline
foamlike1735143foamlike
footlike1537253footlike
foxlike21226223foxlike
froglike1634363froglike
fruitlike1642853fruitlike
gamelike1538033gamelike
gantline9410903gantline
garpike1435093garpike
gemlike14206813gemlike
giantlike1443263giantlike
goadlike1435883goadlike
godlike1387563godlike
grapelike1644663grapelike
grapline1138723grapline
grasslike1443693grasslike
gratine84719193grat_ine
gravelike1744513gravelike
gumlike14317403gumlike
hairlike1536673hairlike
halide103417993ha_lide
halite93624233ha_lite
halolike1537403halolike
handlike1639153handlike
haplite12310703haplite
harelike1539613harelike
hawklike1734493hawklike
heathlike1944323heathlike
henlike1448693henlike
hiplike1637603hiplike
hoblike16158303hoblike
hoelike141411163hoelike
hoglike15157733hoglike
hotline10712353hotline
icelike1337173icelike
inklike1037033inklike
ironlike1235713ironlike
ivylike1734283ivylike
jadelike2035993jadelike
jawline17137063jawline
jazzlike2742683jazzlike
jiglike19105333jiglike
jutelike1935333jutelike
kaoline11310143kaoline
kidlike1137063kidlike
kiltlike1134243kiltlike
kitelike1135733kitelike
knotlike1144003knotlike
lacelike1438493lacelike
ladylike1634683ladylike
lakelike1137383lakelike
lamblike1636153lamblike
lardlike1336503lardlike
latke94817093lat__ke
latrine7715133latrine
lattice938433lattice
lavalike1536283lavalike
leaflike1534713leaflike
leglike12136843leglike
like86040843___like
liplike1337283liplike
loftlike1534393loftlike
malice104818483ma_lice
maline84529083ma_line
marline93320953marline
marlite92917073marlite
masklike1335593masklike
mazelike2336463mazelike
mislike132914833mislike
mothlike1736063mothlike
native9613013nat_ive
nestlike1236083nestlike
niblike1336703niblike
nunlike11258073nunlike
oatcake1345363oatcake
outlie62419533outli_e
outline72321333outline
outlive102513033outlive
owllike1435713owllike
oxlike17307473_oxlike
palmlike1656043palmlike
parklike1337493parklike
pastalike1546723pastalike
patine85328123pat_ine
pattie84020963patti_e
peaklike13115373peaklike
pealike131211273pealike
peglike14136773peglike
piglike14157313piglike
plantlike1544943plantlike
platelike1546143platelike
playlike1735613playlike
podlike14108553podlike
poetlike1436733poetlike
potline91015233potline
praline93019743pra_line
puslike1347563puslike
quaylike2434143quaylike
ragtime1036163ragtime
railing83325643railing
raise54828053ra__ise
rake84841573ra___ke
rale45050563ra_l__e
rallied83514083rallied
rallier73816273rallier
rallies73823343rallies
rallye95110163ra_llye
ramie75027823ra_mi_e
ramilie9310283ramilie
rampikes1635393rampikes
ranchlike1844083ranchlike
ranpikes1435643ranpikes
raphide13138073raphide
rapine85023083ra_pine
ratable91717553ratable
ratafee1047523ratafee
rate45458763rat___e
ratfink1434943ratfink
ratfinks1542853ratfinks
ratfish1338773ratfish
rathe85821923rat__he
rathole10312053rathole
raticide1148943raticide
ratify122610043rat_ify
ratines75328583rat_ines
rating74938703rat_ing
ratio55227583rat_i_o
ration64226013rat_ion
ratios64922673rat_ios
ratites74920683rat_ites
rattier74015593rattier
ratting83822363ratting
rattish10510823rattish
rattle64717613rat_tle
rattling92510873rattling
ravenlike16103863ravenlike
ravine95522223ra_vine
rawhide14134973rawhide
realise73021813realise
realize162717083realize
recline94020493recline
redline84218833redline
reedlike1336213reedlike
reline65434353r_eline
relive95120783r_elive
restrike1239673restrike
retake104718533ret_ake
retie55735303ret_i_e
retile65929673ret_ile
retime85321803ret_ime
retine66237333ret_ine
retire64927013ret_ire
ringlike1336243ringlike
rocklike1335903rocklike
rooflike1534623rooflike
ropelike14157853ropelike
roselike12169183roselike
rubylike1753353rubylike
rufflike1843253rufflike
runelike1236033runelike
rushlike1534333rushlike
rutile65217683rut_ile
sacklike1337303sacklike
saintlike1344783saintlike
saline65132703sa_line
saltie63422433salti_e
saltine75018563saltine
saltire73113043saltire
sandlike1339713sandlike
satire63218003sat_ire
satyrlike1653513satyrlike
scablike1635553scablike
seallike12108323seallike
seamlike14127183seamlike
setline7313923setline
skylike1336103skylike
slablike1435673slablike
slatelike1346153slatelike
slitlike1235303slitlike
snaglike1335283snaglike
soaplike1436903soaplike
sonlike112110713sonlike
sparlike1437673sparlike
starlike1238813starlike
strike105619733_strike
suitlike1236313suitlike
sunlike112310573sunlike
swanlike1535313swanlike
tagline82412453tagline
taillike1237863taillike
talkie103914443ta_lkie
tanklike1136013tanklike
tapelike1437493tapelike
tattie64817513tatti_e
tealike111111083tealike
tentlike1236903tentlike
tike85534483__t_ike
tinlike11248803tinlike
toadlike1336143toadlike
toelike11149823toelike
toylike14157243toylike
tramline10311383tramline
trapline10411863trapline
treelike1237003treelike
trike95320163__trike
trotline8310023trotline
tublike1337083tublike
unalike11311533unalike
unlike102614063_unlike
uralite71714103ura_lite
urnlike1136713urnlike
valine94623093va_line
valise92917643va_lise
vaselike1536993vaselike
vestlike1535393vestlike
waiflike1834573waiflike
wallie93216803walli_e
wasplike1734893wasplike
wavelike1836613wavelike
weblike1635923weblike
wiglike15125853wiglike
wraithlike2051503wraithlike
yeastlike1672993yeastlike

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.406440125.6
2DLD Change Limit1340273497.03019065.0
3Display Results3493490.1262769.8
 (SQL Overall)1786913497.56223630.1
 
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.