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

430 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
hotline1071235(None) 
hotlines11811641hotlines
hotlink1476761hotlink
potline91015231potline
bowline123613112bowline
choline122915382cho_line
cutline92914542cutline
hatlike143311712hatlike
hemline12311072hemline
hipline12311422hipline
hoblike16158302hoblike
hoelike141411162hoelike
hoglike15157732hoglike
holing104025072ho_ling
hoolie93217782hooli_e
hoplite12311072hoplite
hotlinks1574192hotlinks
hottie92514382hotti_e
hotting113116522hotting
howling143413162howling
hutlike14349062hutlike
hyaline132310722hyaline
moline84422032mo_line
online6315842_online
outline72321332outline
plotline1037642plotline
potlike13910122potlike
potlines10714212potlines
ratline74517802ratline
setline7313922setline
topline92313182topline
towline102911542towline
trotline8310022trotline
airline7315033airline
aline57243153__aline
aniline7418473aniline
antlike11312073antlike
batlike133311883batlike
beeline93314723beeline
beltline1036943beltline
berline93716853berline
betaine9413783betaine
boatlike1457963boatlike
boiling103819673boiling
bolide9515563bo_lide
bolling103820883bolling
bolting104416763bolting
boltlike1436313boltlike
bottling11279143bottling
botulin947653botulin_
botulins1047063botulins
bovine11712433bo_vine
bowlike16349473bowlike
bowlines133211623bowlines
bowling133916493bowling
boxlike20267073boxlike
buntline10198063buntline
bustline10208843bustline
butling103516813butling
byline11311643_byline
carline93923623carline
catlike132712933catlike
catlin83819083catlin_
catling104819793catling
catlins93818843catlins
cauline92215603cauline
chitlin12269283chitlin_
chitling142910663chitling
chitlins13289393chitlins
cholines132214493cho_lines
chopine143512263cho_pine
chorine123218363cho_rine
chortling1535563chortling
citrine92514023citrine
cline76428533__cline
coaling103722823coaling
coastline1196363coastline
cocaine111315173cocaine
codeine103815033codeine
codlin94516443codlin_
codling114418953codling
codlins104116243codlins
coiling103723453coiling
colin76231693co_lin_
colins85229043co_lins
collide103214793collide
collie83621993colli_e
collins93419833collins
colone85425003co_lone
combine133014723combine
compline14313553compline
confine12315583confine
coniine9316803coniine
conine84528553co_nine
coolie83821603cooli_e
cooling103422573cooling
corvine122113643corvine
cosine83823513co_sine
coting94629253cot_ing
cotinine10311493cotinine
cowling134017423cowling
cutlines102413273cutlines
dateline9810353dateline
decline103716613decline
doctrine1146733doctrine
doglike13207453doglike
doling84923133do_ling
dolling93817373dolling
domaine10610503domaine
domine92918253do_mine
doolie73916833dooli_e
doting84821913dot_ing
dotting93314483dotting
dourine8311453dourine
entwine1039143entwine
eosine64519413eo_sine
fatlike142911193fatlike
fatling113815683fatling
feline94820143_feline
flatline11298923flatline
foaling113515843foaling
foiling113317653foiling
fooling113117373fooling
footlike1537253footlike
footling12239923footling
fouling113315373fouling
fowling143713113fowling
foxlike21226223foxlike
frontline1245053frontline
frostline1245883frostline
gantline9410903gantline
ghostlike1743353ghostlike
ghoulie1144263ghouli_e
goalie7413163goali_e
goaling93515333goaling
goatlike1346293goatlike
goblin939503goblin_
goblins1039243goblins
godlike1387563godlike
godling103513403godling
gosling93312403gosling
gothite1146403gothite
gumline102810113gumline
gutlike12308653gutlike
guyline11258173guyline
hailing113820693hailing
hairline1137873hairline
halide103417993h_alide
haling104229783h_aling
halite93624233h_alite
halocline1445343halocline
halting114419073halting
haplite12310703haplite
hardline12310273hardline
harmine122816193harmine
hating104929713hat_ing
hatpin112610613hatpin_
hatpins123410643hatpins
hatting113920233hatting
hauling113714433hauling
headline12129613headline
healing113922963healing
heeling113618513heeling
heiling113616363heiling
helling114623223helling
hemlines13310623hemlines
henlike1448693henlike
heroine103517493heroine
hilling113821773hilling
hilting113316893hilting
hiplike1637603hiplike
hiplines13310593hiplines
hircine1239143hircine
hitting113017273hitting
hoagie102310013hoagi_e
hoatzin1943943hoatzin_
hoatzines2143823hoatzines
hoatzins2043843hoatzins
hoaxing18307763hoaxing
hobbing152811123hobbing
hobbling16227583hobbling
hoboing13309453hoboing
hocking173417243hocking
hoddin11369943hoddin_
hoddins12289373hoddins
hoeing104117023ho_eing
hogging133112803hogging
hogmane1336343hogmane
hogtie102711773hogti_e
hogtying1633553hogtying
hoise85224773ho__ise
hoising113414413hoising
hoking144419513ho_king
holden104113953ho_lden
holding123514283holding
hole77553393ho_l__e
holier94921623ho_lier
holies94630033ho_lies
holily123612953ho_lily
holiness112512503ho_liness
holism113713753ho_lism
holist94723213ho_list
holking153512313holking
hollaing12167103hollaing
holland11349473holland
hollies103420813hollies
holloing12148823holloing
holpen11299413ho_lpen
homelike17179533homelike
homie104622533ho_mi_e
homines123518653ho_mines
homing123718383ho_ming
hominine1348913hominine
hominy144511483ho_miny
hondling132210013hondling
hone77549323ho___ne
honing103421503ho_ning
honkie133011673honki_e
honking153414793honking
hoodie105116143hoodi_e
hooding123815203hooding
hoodlike1636563hoodlike
hoofing143912553hoofing
hooflike1834853hooflike
hooking153716693hooking
hooklike1435123hooklike
hooping133615703hooping
hooplike1736773hooplike
hooting113919883hooting
hoping123719743ho_ping
hoplites13310543hoplites
hopping154115273hopping
hoppling16206763hoppling
hording123517053hording
hormone12410503hormone
horning113015003horning
hornlike1536503hornlike
horsing113215583horsing
hoselike15179643hoselike
hosing103421103ho_sing
hospice14117063hospice
hosteling1337893hosteling
hostile10312553hostile
hosting114318383hosting
hotcake1644543hotcake
hotching17309313hotching
hotelier1137633hotelier
hotelmen1344193hotelmen
hotly115815483hotl__y
hotties103016963hotties
hottish13117903hottish
housing113316523housing
hoveling15189593hoveling
howdie13349733howdi_e
howking183610313howking
hoyle11314413hoyl__e
hulling113619013hulling
hurling113616413hurling
hurtling12318313hurtling
hustling12228793hustling
hutting113016033hutting
hyalin122210043hyalin_
hyalines14169333hyalines
hyalins13229273hyalins
hyalite13229473hyalite
hyenine1336953hyenine
hyoscine1644183hyoscine
incline9314643incline
intine61021983int_ine
intwine1038513intwine
iodine74618653io_dine
iolite63221983io_lite
isocline1047293isocline
isoline7314013isoline
jawline17137063jawline
jetlike18276763jetlike
jetliner1534853jetliner
jolting153410913jolting
jostling16207123jostling
jotting152912773jotting
kaoline11310143kaoline
kitling123313573kitling
knotlike1144003knotlike
koine9516483ko__ine
latrine7715133latrine
line46965573___line
lobeline1039963lobeline
loftlike1534393loftlike
lolling83415783lolling
longline938763longline
lotting82917753lotting
lowlife1335143lowlife
maline84529093_maline
marline93320973marline
midline102315103midline
milline92519113milline
moatlike1446993moatlike
moiling103417663moiling
mollie83517103molli_e
molting103517173molting
moraine9314573moraine
mothlike1736063mothlike
motile83818343mot_ile
motive113112143mot_ive
motlier92010583motlier
mottling11197753mottling
moulin8313283moulin_
moulins9312703moulins
mutine84420373mut_ine
myeline1238253myeline
netlike11308913netlike
nonlife1038553nonlife
nothing113511903nothing
notice8313443not_ice
noting74120153not_ing
nutlike113110113nutlike
oatlike113412403oatlike
oblige937653_oblige
offline1345783offline
ogling83211883_ogling
oiling74925313_oiling
oleine6313793_oleine
olive84817153_o_live
oodlins83210513oodlins
oolite63319603_oolite
opaline9412483opaline
opine77422463_o_pine
orpine83914483_orpine
oscine8311563_oscine
outlie62419533outli_e
outlined92512953outlined
outliner82412113outliner
outlines82418093outlines
outlive102513033outlive
ovine86316643_o_vine
oxlike17307473_oxlike
patine85328123pat_ine
petaline10314883petaline
phocine1438833pho_cine
photoing1439073photoing
plotlines1146823plotlines
podlike14108553podlike
poetlike1436733poetlike
police102918563po_lice
poling93526503po_ling
polite83625073po_lite
polling102920383polling
pontine92419053pontine
pooling103219093pooling
poplin10413483poplin_
poplins11313153poplins
porcine11312843porcine
potpie103412433potpi_e
potsie83916033potsi_e
potting103720893potting
poutine93316823poutine
praline93019743praline
proline92321593proline
purline93516533purline
ralline73518413ralline
ratine65131823rat_ine
ratlike113912353ratlike
ratlin64116523ratlin_
ratlines83815293ratlines
ratlins73615583ratlins
recline94020493recline
redline84218833redline
reline65434353_reline
retine66237333ret_ine
rodlike1288263rodlike
roiling83220453roiling
rolling83620413rolling
romaine9512123romaine
roofline1136193roofline
rootlike1236613rootlike
rootling9269953rootling
rotting82919683rotting
routine72615903routine
saline65132703_saline
saltine75018563saltine
setlines8312743setlines
shoaling123111753shoaling
shooling123012563shooling
shoreline1246623shoreline
shotting123012383shotting
skyline1436793skyline
soiling83422323soiling
soling74226823so_ling
sonlike112110713sonlike
sordine82515233sordine
sozine15712353so_zine
spline86020533_spline
subline9316893subline
tagline82412453tagline
thine85026863__thine
tholing112812333tho_ling
tine45855133__t_ine
titling83715793titling
toelike11149823toelike
toiling83219023toiling
tolane64316583to_lane
toling73926123to_ling
tolling83418563tolling
tontine72316143tontine
tooling82918313tooling
tootling9279523tootling
toplines102412563toplines
totaling9610303totaling
totalise8312503totalise
totalize17311523totalize
toting74123793tot_ing
totting82816843totting
towlines112610343towlines
toxine133114123to_xine
toylike14157243toylike
trine54734603__trine
trotlines939103trotlines
twine85822363__twine
untwine1038623untwine
valine94623093_valine
vitrine102511363vitrine
vituline1147093vituline
voling103918023vo_ling
voting103916033vot_ing
votive12348933vot_ive
witling113215813witling
woolie93514483wooli_e
wotting112913843wotting
yodling123610253yodling
yowling143610223yowling

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.403443402.0
2DLD Change Limit1340274306.80019709.9
3Display Results4304300.1562756.4
 (SQL Overall)1786914307.35924282.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.