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

448 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
pontil831546(None) 
pontils9312211pontils
apostil947902apostil
dentil74017882dentil
fontal9313142fontal
gentil74115122gentil
lentil64315392lentil
ontic74418572_ontic
pantie84326472pantie
pantile93918482pantile
pastil85018322pastil
pencil103712972pencil
pensil83013332pensil
pentyl1138812pentyl
pintail9311182pintail
pistil83915072pistil
poetic10416842poetic
pongid104111582pongid
pontes83627852pontes
pontiff1547902pontiff
pontine92419052pontine
ponton83217642ponton
ponytail1344552ponytail
portal84218462portal
postal84317532postal
postie84123962postie
postin83521032postin
tonsil6311872tonsil
until53517742_until
agnail739533agnail
anil46437433_an_il
anti45536363_anti_
antic75728863_antic
antis55033313_antis
anvil82712603_anvil
aortal65217513aortal
aortic8316613aortic
apostils1046773apostils
auntie64317703auntie
biontic1148333biontic
boatel84314093boatel
bobtail1146553bobtail
boil66335183bo__il
bonita8312943bonita
bonito8313433bonito
bonnie85314853bonnie
bonnily1236873bonnily
bootie85421163bootie
botel75121863bo_tel
cantal84122033cantal
cantic103920543cantic
cental84420963cental
centile94217183centile
coati75624643coati_
coatis85122603coatis
coil66439653co__il
coital84117053coital
confit113316403confit
congii957363congii
coni65534803con_i_
conic95329793con_ic
conin76232723con_in
conoid9818883conoid
consol82614113consol
consul82312303consul
contain9315833contain
conte76633203cont_e
contes84432913contes
conto76027173cont_o
contos84923233contos
contra83314703contra
contrail10410983contrail
control9310693control
coontie9311423coontie
cootie84223093cootie
cortin82423153cortin
costal85419513costal
council1137473council
dental74319173dental
dentils84115583dentils
dentin73919573dentin
deontic1038883deontic
distil73616433distil
donsie7613643donsie
donzel1636313donzel
dossil75110903dossil
dotal64919623do_tal
dottel73610893dottel
dottily1147283dottily
entail61114343_entail
entia5318203_entia
entoil6912493_entoil
fantail10310233fantail
foetal9311883foetal
foetid10510513foetid
foil76433913fo__il
font77143753font__
fontina1038633fontina
fonts86124753font_s
footie94718143footie
fortis95418613fortis
fossil9379353fossil
foxtail1745383foxtail
frontal1038363frontal
gentile83515293gentile
gonia64117533gon_ia
gonif94320923gon_if
goutily1137933goutily
hobnail1243973hobnail
hogtie102711773hogtie
hongi96715873hongi_
honkie133011673honkie
horntail11105033horntail
hostel93914153hostel
hostile10312553hostile
hotel85520753ho_tel
hottie92514383hottie
instil61111383instil
inti46626083_inti_
intis55121643_intis
ionic74622663ion_ic
joltily1746323joltily
jonquil2342773jonquil
lentic83515743lentic
lentils73912973lentils
lintel64013993lintel
lintol6369473lintol
loftily1336353loftily
loti46431843lo_ti_
lotic76420673lo_tic
mantel84317973mantel
mantic104120903mantic
mantid93820383mantid
mantis83926033mantis
mental84521603mental
moil65534093mo__il
mongol94912533mongol
monie75631653mon_ie
monofil1247273monofil
monte75829773mont_e
montes84226933montes
month104818423mont_h
monthly1535673monthly
months113812933months
mortal84616853mortal
motel76623243mo_tel
motif10519683mo_tif
motile83818343mo_tile
muntin82915183muntin
nail45838653__nail
nil36144193__n_il
noetic8514043noetic
noil46133243__noil
nonoily1049543nonoily
nontax1348413nontax
nontidal948673nontidal
nontitle846943nontitle
nonyl849773non_yl
nostril749303nostril
notal55221353no_tal
octal71214723_octal
octyl10136063_octyl
oil37452053_o__il
onto46127663_ont_o
ootid61416703_ootid
optic93715183_optic
opuntia9134153opuntia
ostia52315583_ostia
otic66624823_o_tic
oxtail1337653_oxtail
pail66141833p__ail
pandit93820753pandit
panel76023623pan_el
panful1179743panful
panic93923903pan_ic
pant66061263pant__
panted95024823panted
panties94230933panties
pantiled113111593pantiled
pantiles103617153pantiles
panting104025423panting
panto76129413pant_o
pantos85222743pantos
pantry115014103pantry
pants76536923pant_s
panty105929303pant_y
partial92616263partial
pastel85918713pastel
pastie85525523pastie
pastils94416173pastils
pastis84924323pastis
patin76832853p_atin
patio74426353p_atio
pattie84020963pattie
pectic122913873pectic
pectin102615533pectin
penal75228373pen_al
pencel103812913pencel
pencils113011773pencils
penial84120893penial
penicil1138833penicil
penile82219603pen_ile
penis75129323pen_is
penni74617903penni_
pennia84412973pennia
pennis84315743pennis
pensile92713543pensile
pensils92811593pensils
pent66559073pent__
pentad9313763pentad
pentyls1236523pentyls
peptic122113153peptic
peptid112712373peptid
peril75425953p_eril
petal76526893p_etal
petit74332653p_etit
petti75119453petti_
pettily1238173pettily
phatic133014413phatic
phonal11310383phon_al
phonetic15310323phonetic
phonic133315213phon_ic
phonily1537103phon_ily
photic133316443photic
phytin14459013phytin
phytol14366563phytol
pigtail1046623pigtail
pineal84817683pineal
pinite8321243pinite
pinitol936683pinitol
pinkie124414273pinkie
pinnal84814273pinnal
pint66963173pint__
pinta75727053pint_a
pintails10310163pintails
pintas85021393pintas
pintle83818263pintle
pinto75625753pint_o
pintos86021293pintos
pints75936223pint_s
pinyin112710613pinyin
pionic103515953pion_ic
pistils93314303pistils
pistol83313333pistol
pockily1846233pockily
podgily1435213podgily
podia8415283po_dia
podite93315353podite
poditic122611583poditic
podsol946853podsol
podzol1835083podzol
poet65552903poet__
poetical12311533poetical
poetics11312073poetics
poetise9314043poetise
poetize18310773poetize
poetry1139383poetry
poets76024443poet_s
poi57244663po__i_
poilu72316003po__ilu
point75338733point__
pointe84619313point_e
pointed103813983pointed
pointer93814933pointer
pointes93216753pointes
pointier1038303pointier
pointing112813683pointing
points85618533point_s
pointy114913283point_y
pois66539043po__is
poitrel936193poitrel
pokily15309063po_kily
pol56449383po___l
poleis86018353poleis
polio75722553po_lio
polis74731163po_lis
polite83625073polite
politic112918713politic
polity113015863polity
poll66332133po__ll
polyol1138713polyol
pommel12277453pommel
pommie123710503pommie
ponce95222513pon_ce
ponced114314813ponced
ponces104720843ponces
poncho133310123poncho
poncing122913583poncing
pond75530493pon__d
ponded105218773ponded
ponder94521693ponder
ponding114317083ponding
ponds85323403pon_ds
pone65747533pon__e
ponent82821593ponent
pones74547043pon_es
pong76231143pon__g
ponged105619353ponged
pongee94920193pongee
pongids11347413pongids
ponging113416153ponging
pongs85526343pon_gs
ponied94920703ponied
ponies84833463ponies
pons65850603pon__s
pontifex2043253pontifex
pontiffs1643143pontiffs
pontific1545563pontific
pontons93315553pontons
pontoon93010703pontoon
pony96434053pon__y
ponying133312123ponying
ponytails1443653ponytails
pool65835953po__ol
poori74816233poori_
pooris83916843pooris
poplin10413483poplin
popsie103013053popsie
port66059633port__
portals94015563portals
ported94223243ported
porter84224413porter
portico11310143portico
porting103021783porting
portion9615493portion
portly114713403portly
ports75934593port_s
posit75833333po_sit
posits85718713posits
post67953363post__
postals93716373postals
posted93722493posted
poster84129173poster
postfix1944683postfix
posties93128813posties
posting105622243posting
postins93721203postins
postop10511943postop
posts75228783post_s
pot58078433po_t__
potboil1195463potboil
potential1148533potential
potful1138083potful
potion84519573po_tion
potpie103412433potpie
pots66452363po_t_s
potsie83916033potsie
potsy105815613po_tsy
potted94624013potted
potter83926983potter
pottier93516493pottier
potties93723543potties
potting103720893potting
pottle84416103pottle
potto75320943po_tto
pottos84615873pottos
potty105621003po_tty
poundal1036403poundal
pout65752553pout__
pouted94021393pouted
pouter83923983pouter
poutful1236743poutful
poutier93215323poutier
poutine93316823poutine
pouting103519943pouting
pouts75530323pout_s
pouty107018813pout_y
powter114116033powter
pronto8313993pront_o
prostie91617743prostie
protyl11308213protyl
psoatic1139303psoatic
ptotic102713373ptotic
pundit92914183pundit
punily11311773pun_ily
punji1438203punji_
punjis1536693punjis
punkie123513613punkie
punkin123611523punkin
punt65747203punt__
punted94618713punted
punter84320023punter
punties94520783punties
punting103318443punting
punto75121323punt_o
puntos85915793puntos
punts75828003punt_s
punty106021613punt_y
pupil94712983p_upil
putti76018743putti_
puttie84116303puttie
ramtil8311023ramtil
renail65020763renail
rental63922023rental
roil46235293ro__il
rondel73212643rondel
ronnel63310883ronnel
roti46332933ro_ti_
rotis56327063ro_tis
rotl45029683ro_t_l
santir6315253santir
santol64515243santol
senti56226703senti_
snail57020203_snail
softie93312483softie
soil46138833so__il
sonic75225293son_ic
sonsie6614863sonsie
sootily101810523sootily
sortie63621993sortie
sotol54917653so_tol
spoil75818653spo__il
spongily1444903spongily
spongin1036373spongin
sponsal946343sponsal
sportif1238803sportif
sportily1337733sportily
spottily1335153spottily
tenail64516113tenail
tentie62521183tentie
til36350263___til
toenail738783toenail
toil46536283to__il
tomtit8413853tomtit
tonal53724303ton_al
tondi65716143tondi_
tonetic9313433tonetic
tonic74727653ton_ic
tonsils7310183tonsils
tontine72316143tontine
tortile7313193tortile
total55321823to_tal
unnail6410583unnail
untie54425493_untie
ventail10310453ventail
volti84915963volti_
wont75842503wont__
wonted103213283wonted
wonting113214103wonting
wonton93410963wonton
wonts87621543wont_s
wormil1138043wormil
yoni77524393yon_i_
yonic105920843yon_ic
yonis85020823yon_is
zoftig1932973zoftig
zonal145116853zon_al
zoril143916693zo_ril

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 Filter1786911127160.440406115.9
2DLD Change Limit1127164485.39020912.1
3Display Results4484480.1562871.8
 (SQL Overall)1786914485.98629851.5
 
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.