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

303 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
prolix153868(None) 
frolic1149202frolic
polio75722552p_olio
polis74731162p_olis
prefix18356852prefix
prelim10311422prelim
premix173710332premix
probit103218352probit
profit113016272profit
prolan8414692prolan
prole74527792prol_e
proleg94612112proleg
proles84627202proles
proline92321592proline
prolixly2043112prolixly
prolog94212972prolog
prosit85124592prosit
aioli5318313aioli_
aiolis6316843aiolis
aprotic112715243aprotic
aroid65428343aro_id
bollix1538053bollix
broil74918223bro_il
broils84114173broils
brolly114510853brolly
bromic122412693bromic
bromid112612893bromid
bromin102615693bromin
calix145317353_calix
caroli85918233caroli_
colic95726173_colic
colin76231693_colin
comix163513203_comix
coolie83821603coolie
croci95818133croci_
crojik1934113crojik
cylix17448623_cylix
doolie73916833doolie
droid74218543dro_id
droit65127123dro_it
droll65415403drol_l
drolls75312393drolls
drolly105411673drolly
enolic8413353enolic
erotic82620273erotic
folia83618933_folia
folic105319323_folic
folio83820883_folio
fornix1636033fornix
frolics1236833frolics
groin65521083gro_in
helix154413013_helix
hoolie93217783hoolie
ironic8313773ironic
kaolin1039583kaolin
kylix19416323_kylix
neroli61111153neroli_
nerolis71012773nerolis
oboli73712873oboli_
olio46829673__olio
ovoli8358283ovoli_
pallia83015593pallia
pallid93915283pallid
parodic122311723parodic
parol74826273parol__
parole84425253parol_e
paroled104217633paroled
parolee94119643parolee
paroles95025883paroles
paroling113316213paroling
parols84722613parol_s
parotic112518043parotic
parotid102915513parotid
parvolin1376933parvolin
paulin8312983paulin
peroxid17310273peroxid
perplex1836153perplex
petrolic1249693petrolic
phenix1837133phenix
phlox1737333p_hlox
phobia13278603phobia
phobic153010073phobic
phoenix1944363phoenix
phonic133315213phonic
photic133316443photic
phylic16279553phylic
picolin11310883picolin
pili66130353p_ili_
pilis75825203p_ilis
piolet83225643piolet
pionic103515953pionic
pirogi9299013pirogi_
pix126437933p___ix
plex137321373p__lex
plie65127393p__lie
podia8415283p_odia
poi57244663p_o_i_
poilu72316003p_oilu
pois66539043p_o_is
pol56449383p_ol__
polar75623453p_olar
pole65951303p_ol_e
poleax1547993p_oleax
poled84934843p_oled
poleis86018353p_oleis
poler74431793p_oler
poles75351003p_oles
police102918563p_olice
policy133211513p_olicy
polies84034583p_olies
poling93526503p_oling
polios84019723p_olios
polish114916723p_olish
polite83625073p_olite
polity113015863p_olity
polka11310413p_olka
poll66332133p_ol_l
pollex153711163pollex
polls74627723p_olls
polo66236633p_ol_o
polos76129913p_olos
pols66044563p_ol_s
poly96235153p_ol_y
polyp125611533p_olyp
polys105718763p_olys
pool65835953pool__
pooled94619813pooled
pooler83819843pooler
pooling103219093pooling
pools74427703pool_s
poori74816233poori_
pooris83916843pooris
poplin10413483poplin
posit75833333p_osit
pox126140693p_o__x
praline93019743praline
praxis154012253praxis
prebid113512843prebid
precis103416703precis
prelaw1139103prelaw
prelife1279943prelife
prelims1139823prelims
premie103617993premie
premixt183510663premixt
pretax152310193pretax
prex135722973pr__ex
prig75924873pr__ig
prill74117943pril_l
prills84015613prills
prim85132203pr__im
primi95017403primi_
pro55837263pro___
proa66229963pro__a
proas75028803pro_as
probe94320813pro_be
probed114114823probed
prober104516073prober
probes104119453probes
probing123314443probing
probits112712573probits
probity14299683probity
problem1335983problem
proclaim1446073proclaim
prod76129503pro__d
prodigy1435573prodigy
prods85523553pro_ds
proem94818273pro_em
proems104711163proems
prof96134663pro__f
profile123211153profile
profits122911243profits
profs105120893pro_fs
prog75729003pro__g
progs86624153pro_gs
progun968783progun
projet15315183projet
prolamin12139753prolamin
prolans9314273prolans
prolate9419793prolate
prolegs10379993prolegs
prolific1546743prolific
prolines102619693prolines
prolixity2144863prolixity
prologs103512133prologs
prolong10319633prolong
prom87631703pro__m
promine112819443promine
promise113415843promise
promo95620003pro_mo
promos105116423promos
prompt12313013prompt
proms95426413pro_ms
prone75332623pro_ne
prong85218113pro_ng
prongs94314483prongs
pronto8313993pronto
proof105221533pro_of
proofs114511683proofs
prop85932813pro__p
propel103714063propel
proper104319953proper
propine113020213propine
propolis12311403propolis
propria1149933propria
props95726883pro_ps
propyl13358183propyl
propylic1747183propylic
pros65742783pro__s
prosaic11311163prosaic
prose75835123pro_se
prosed94921093prosed
proser84223463proser
proses84733473proses
prosier93817483prosier
prosily12611633prosily
prosing103319383prosing
proso77222413pro_so
prosos85718553prosos
pross76529403pro_ss
prossie91812953prossie
prost75434103pro_st
prostie91617743prostie
prosy106319253pro_sy
protea82214763protea
protei82615313protei
proteid103513673proteid
protein92414733protein
protist9320223protist
protium11312293protium
proton84318893proton
protyl11308213protyl
proud84615483pro_ud
prove104823193pro_ve
proved125016033proved
proven114314773proven
prover113819723prover
proves114322253proves
provide1339853provide
proving134214073proving
proviso1237313proviso
prow97030383pro__w
prowar114110943prowar
prower114218123prower
prowl105615123pro_wl
prowled13309913prowled
prowler123310013prowler
prowling1449993prowling
prowls115511083prowls
prows106327013pro_ws
proxies163014933proxies
proximo1845143proximo
proxy175011013pro_xy
psoai7469923psoai_
psocid1137253psocid
ptosis83611823ptosis
ptotic102713373ptotic
public12238143public
puli65527623p_uli_
pulik113613303p_ulik
pulis74225603p_ulis
purlin83615863purlin
purloin9107493purloin
pyoid11513763pyo_id
pyosis114012123pyosis
pyralid1347983pyralid
pyrola1139003pyrol_a
pyrolas1239863pyrolas
pyrolize2248133pyrolize
pyrosis12411653pyrosis
pyrrolic1544563pyrrolic
radix134414603_radix
refix155212483_refix
relax124817803_relax
relic74623363_relic
relit55340683_relit
remix145916553_remix
robin74820283_robin
roil46235293_ro_il
roils54826793_roils
roily86121113_roily
role45851823_rol_e
roles56747983_roles
rolf75134873_rol_f
rolfs84817123_rolfs
roll46331653_rol_l
rolls55326233_rolls
rosin55325313_rosin
roti46332933_roti_
rotis56327063_rotis
roux117419363_ro_ux
scolex1538243scolex
soli46637013_soli_
solid65025083_solid
stolid74213183stolid
trois57226093tro_is
troll54416533trol_l
trolls64613943trolls
trolly94012363trolly
tropic103014193tropic
tropin83316753tropin
urolith1048783urolith
violin9311983violin
woolie93514483woolie

Search took 6 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.390458182.1
2DLD Change Limit1127163035.12322002.0
3Display Results3033030.0963156.3
 (SQL Overall)1786913035.60931857.9
 
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.