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

470 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
potline9101523(None) 
hotline10712341hotline
plotline1037641plotline
potlike13910121potlike
potlines10714211potlines
bowline123613112bowline
cutline92914542cutline
hotlines11811642hotlines
hotlink1476752hotlink
moline84422032mo_line
online6315842_online
opaline9412482opaline
outline72321332outline
patine85328122pat_ine
petaline10314882petaline
plotlines1146822plotlines
podlike14108552podlike
poetlike1436732poetlike
police102918562po_lice
poling93526502po_ling
polite83625072po_lite
polling102920382polling
pontine92419052pontine
pooling103219092pooling
poplin10413482poplin_
poplins11313152poplins
porcine11312842porcine
potpie103412422potpi_e
potsie83916022potsi_e
potting103720892potting
poutine93316822poutine
praline93019742praline
proline92321592proline
purline93516532purline
ratline74517802ratline
setline7313922setline
topline92313182topline
towline102911542towline
trotline8310022trotline
airline7315033airline
aline57243153__aline
aniline7418473aniline
antlike11312073antlike
apocrine1246933apocrine
apolune945283apo_lune
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
carline93923613carline
catlike132712933catlike
catlin83819073catlin_
catling104819793catling
catlins93818843catlins
cauline92215603cauline
choline122915383choline
citrine92514023citrine
cline76428533__cline
coaling103722823coaling
coastline1196353coastline
cocaine111315173cocaine
codeine103815033codeine
codlin94516433codlin_
codling114418953codling
codlins104116243codlins
coiling103723453coiling
colin76231693co_lin_
colins85229043co_lins
collide103214783collide
collie83621993colli_e
collins93419833collins
colone85425003co_lone
combine133014713combine
compline14313553compline
confine12315583confine
coniine9316803coniine
conine84528553co_nine
coolie83821603cooli_e
cooling103422573cooling
corvine122113643corvine
cosine83823513co_sine
coting94629253cot_ing
cotinine10311493cotinine
cowling134017413cowling
cutlines102413273cutlines
dateline9810353dateline
decline103716613decline
doctrine1146733doctrine
doglike13207453doglike
doling84923133do_ling
dolling93817373dolling
domaine10610503domaine
domine92918253do_mine
doolie73916833dooli_e
doting84821913dot_ing
dotting93314483dotting
dourine8311443dourine
entwine1039143entwine
eosine64519413eo_sine
fatlike142911193fatlike
fatling113815683fatling
feline94820143_feline
flatline11298923flatline
foaling113515843foaling
foiling113317653foiling
fooling113117373fooling
footlike1537253footlike
footling12239923footling
fouling113315373fouling
fowling143713113fowling
foxlike21226223foxlike
frontline1245053frontline
frostline1245873frostline
gantline9410903gantline
goalie7413153goali_e
goaling93515333goaling
goatlike1346293goatlike
goblin939503goblin_
goblins1039243goblins
godlike1387563godlike
godling103513403godling
gosling93312403gosling
gothite1146403gothite
gumline102810113gumline
gutlike12308653gutlike
guyline11258173guyline
hatlike143311713hatlike
hemline12311073hemline
hipline12311423hipline
hoblike16158303hoblike
hoelike141411163hoelike
hoglike15157733hoglike
holing104025073ho_ling
hoolie93217773hooli_e
hoplite12311073hoplite
hotlinks1574193hotlinks
hottie92514363hotti_e
hotting113116513hotting
howling143413163howling
hutlike14349063hutlike
hyaline132310723hyaline
incline9314643incline
intine61021973int_ine
intwine1038513intwine
iodine74618643io_dine
iolite63221973io_lite
isocline1047293isocline
isoline7314013isoline
jawline17137063jawline
jetlike18276763jetlike
jetliner1534853jetliner
jolting153410913jolting
jostling16207123jostling
jotting152912773jotting
kaoline11310143kaoline
kitling123313573kitling
knotlike1143993knotlike
koine9516483ko__ine
latrine7715123latrine
line46965573___line
lobeline1039963lobeline
loftlike1534393loftlike
lolling83415773lolling
longline938763longline
lotting82917753lotting
lowlife1335143lowlife
maline84529083_maline
marline93320953marline
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
opalines10311423opalines
opine77422463_o_pine
optime1079343opt_ime
opting94514403opt_ing
orpine83914483_orpine
oscine8311563_oscine
outlie62419523outli_e
outlined92512953outlined
outliner82412103outliner
outlines82418093outlines
outlive102513033outlive
ovine86316643_o_vine
oxlike17307473_oxlike
paling93530133p_aling
palling104024483palling
pardine103616723pardine
parling103823763parling
patin76832853pat_in_
patina86022193pat_ina
patinae95414403pat_inae
patined105114783pat_ined
patines95225763pat_ines
patins87528783pat_ins
pattie84020963patti_e
patting103722343patting
paulin8312983paulin_
paulins9312613paulins
pealike131211273pealike
pealing104123203pealing
peeling102919873peeling
peglike14136773peglike
pelite84323003p_elite
pelting102917273pelting
pemoline12310273pemoline
penlite9313243penlite
pennine93712953pennine
peopling1338353peopling
pepsine11310603pepsine
perlite9317313perlite
pestling111010253pestling
petite84320653pet_ite
petting103720953petting
pettling1168213pettling
phocine1438833phocine
photoing1439063photoing
picoline12310853picoline
piglike14157313piglike
piling95025593p_iling
pilling103722563pilling
pine67755713p___ine
pipeline12149493pipeline
piscine11610973piscine
pithing134014053pithing
pitting103618873pitting
pitying132910243pitying
plane74929143p__lane
plie65127393p__li_e
plink115219123p__link
plotting113011013plotting
plotzing20276143plotzing
poblano1145093poblano
pocking163916763pocking
podding124113183podding
podite93315353po_dite
poetise9314043poetise
poetize18310773poetize
poind84217913po__ind
point75338733po__int
pointe84619313po__inte
poise75127893po__ise
poising103617103poising
poking133819303po_king
pole65951303po_l__e
policed123212233po_liced
policer113112683po_licer
polices113118053po_lices
policy133211513po_licy
polies84034583po_lies
polio75722553po_li_o
polios84019723po_lios
polis74731163po_li_s
polish114916723po_lish
politer92417073po_liter
polity113015863po_lity
pollee83623273po_llee
pollen83416453pollen_
pollened1157773pollened
pollens93713303pollens
pollices12410753pollices
pollinate1147713pollinate
pollinia1046803pollinia
pollinic1247333pollinic
pollinize2046893pollinize
pollist9816603pollist
pollute937383pollute
polyene1259363polyene
pommie123710503pommi_e
poncing122913583poncing
ponding114317083ponding
pone65747533po___ne
ponging113416153ponging
ponying133312123ponying
poohing133112323poohing
pooing93820683po_oing
poolside1145043poolside
pooping123615443pooping
popelike16177853popelike
poplitei1245483poplitei
popping113715413popping
poppling12227323poppling
popsie103013053popsi_e
porcini1137633porcini
porcino1138113porcino
poring94227273po_ring
porking143515813porking
porting103021783porting
portlier1038373portlier
portliness1246833portliness
portside1138163portside
posing93922643po_sing
postdive1445763postdive
postfire1346273postfire
postie84123963posti_e
postin83521033postin_
posting105622243posting
postins93721203postins
postlude1144543postlude
postpone1248693postpone
potable112115363potable
potage92715903pot_age
poteen83514263poteen_
poteens92910883poteens
potence11711363potence
potent84223353pot_ent
potheen12257893potheen
pothole12312173pothole
potiche1438043potiche
potion84519573pot_ion
potions93417423potions
potlach14106363potlach
potlache15114283potlache
potluck1544033potluck
potman102813573potman_
potmen102713093potmen_
potpies113116173potpies
potsies93019483potsies
potstone1039423potstone
pottage103310603pottage
potteen9319673potteen
pottier93516493pottier
potties93723543potties
pottiness1179693pottiness
pottle84416103pot_tle
poultice1246063poultice
pouring103115863pouring
poutines102415103poutines
pouting103519943pouting
poxing163714943po_xing
pralines102217723pralines
prelife1279943prelife
primine113214823primine
procaine12312273procaine
prolines102619693prolines
promine112819443promine
propine113020213propine
protamine131310913protamine
proteide11239723proteide
protein92414723protein_
proteins102114283proteins
prowling1449993prowling
ptomaine1245533ptomaine
puling93621403p_uling
pulling103821073pulling
purine85321893p_urine
purlin83615863purlin_
purlines103514053purlines
purling103620293purling
purlins93415423purlins
puslike1347563puslike
puttie84116303putti_e
putting103218573putting
putzing19359123putzing
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
skyline1436793skyline
soiling83422323soiling
soling74226823so_ling
sonlike112110713sonlike
sordine82515223sordine
sozine15712343so_zine
spline86020533_spline
spoiling112911553spoiling
spooling113212563spooling
spotlit947283spotli_t
spotting112812083spotting
subline9316893subline
tagline82412453tagline
thine85026853__thine
tine45855133__t_ine
titling83715793titling
toelike11149823toelike
toiling83219023toiling
tolane64316583to_lane
toling73926123to_ling
tolling83418563tolling
tontine72316143tontine
tooling82918313tooling
tootling9279523tootling
toplines102412563toplines
totaling9610293totaling
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 9 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.1561145455.1
2DLD Change Limit1340274708.59615591.8
3Display Results4704700.1702764.7
 (SQL Overall)1786914708.92220028.1
 
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.