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

353 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
prolog9421297(None) 
proleg94612111proleg
prologs103512131prologs
prolong10319631prolong
apolog938902apolog
colog86619932_colog
duolog835802duolog
isolog737402isolog
orology11319462orology
photog12379812photog
polo66236632p_olo_
polos76129912p_olos
prog75729002pr__og
prolan8414692prolan
prole74527792prol_e
prolegs10379992prolegs
proles84627202proles
prolix1538682prolix
prologed12189202prologed
prologue1146832prologue
prolonge11388402prolonge
prolongs11347612prolongs
promo95620002promo_
promos105116422promos
prong85218112pro_ng
proof105221532pro_of
proso77222412proso_
prosos85718552prosos
proton84318892proton
putlog965552putlog
pyrology17136822pyrology
urology11217582urology
aerology1238743aerology
agrology1336023agrology
analog7159973analog
apiology1436563apiology
apologs1038593apologs
apology1337913apology
apropos1138843apropos
areology1237383areology
beclog1136863beclog
biology1337363biology
blog75723823__blog
bolo65535953_bolo_
bolos75531373_bolos
brolly114510853brolly
bromo95217203bromo_
bromos104213313bromos
broo65129823bro_o_
brood84620243bro_od
brook114717763bro_ok
broom95022213bro_om
broos75126413bro_os
brulot8912213brulot
bryology1744513bryology
cholo105217973cholo_
cholos114716853cholos
clog76123243__clog
cohog117813043_cohog
cologs96517353_cologs
colon78630193_colon
color76123743_color
coprology1755723coprology
crook115217573cro_ok
croon75522783cro_on
croton84415453croton
dialog837973dialog
dolor67617963_dolor
droll65415403drol_l
drolls75312393drolls
drolly105411673drolly
dromon939363dromon
drongo836793drongo
drool65416103dro_ol
drools74412813drools
drooly104911073drooly
droop85814823dro_op
drylot1037403drylot
duologs935363duologs
ecology13218823ecology
enology11239813enology
epilog976463epilog
erelong835593erelong
flog85523893__flog
frog85624363fr__og
frolic1149203frolic
geology12257323geology
grog65923343gr__og
groom85317983gro_om
homolog1346963homolog
horologe1248363horologe
horology1548123horology
iroko939663iroko_
irokos1037233irokos
isologs837433isologs
kolo87026223_kolo_
kolos94921213_kolos
kronor10417233kronor
kroon94514483kro_on
log46252683___log
monolog10259353monolog
myology1636163myology
neology11238293neology
nolo46229313_nolo_
nolos54423353_nolos
ology94113113__ology
oology103210253_oology
oolong738073_oolong
orlon5415003or_lon
orlop7410903or_lop
otology11308753otology
ovolo8339173ovolo_
ovolos9257203ovolos
pallor8313673pallor
parlor8312673parlor
parodoi10267723parodoi
parodos103011753parodos
parol74826273parol__
parole84425253parol_e
paroled104217623paroled
parolee94119633parolee
paroles95025883paroles
paroling113316213paroling
parols84722613parol_s
pedology15216903pedology
pelon74423213p_elon
penology14238483penology
peplos101211543peplos
petrology1547333petrology
phlox1737333p_hlox
phono104917023phono_
phonon114012033phonon
phonos114114793phonos
photo104417233photo_
photogs13358213photogs
photon1111514833photon
photos113316643photos
phylon14318033phylon
pillow113110573pillow
pilot77435063p_ilot
piolet83225643piolet
pirog83913673p_irog
plod76723273p__lod
plop86625743p__lop
plot66141233p__lot
plow95923233p__low
ploy96123603p__loy
plug74915993p__lug
poboy121612223p_oboy
poco86826153p_oco_
pol56449383p_ol__
polar75623453p_olar
pole65951303p_ol_e
poled84934843p_oled
poler74431793p_oler
poles75351003p_oles
poling93526503p_oling
polio75722553p_olio
polios84019723p_olios
polis74731163p_olis
polka11310413p_olka
poll66332133p_ol_l
polls74627723p_olls
pols66044563p_ol_s
poly96235153p_ol_y
polyol1138713p_olyol
polyp125611533p_olyp
polys105718763p_olys
pomo85828453p_omo_
pomology1637193pomology
pomos95321583p_omos
pong76231143p_o_ng
poo57757113p_o_o_
pood75934323p_o_od
poof95541663p_o_of
pooh96027383p_o_oh
pooing93820683pooing
pool65835953p_o_ol
pooled94619813pooled
pooler83819843pooler
pooling103219093pooling
pools74427703pool_s
poon67341263p_o_on
poop86532813p_o_op
poor65630223p_o_or
poos65949113p_o_os
poring94227273poring
porno75120653porno_
pornos85015253pornos
posology1447243posology
poyou102611523p_oyou
prang84820323pr_ang
prao66229023pr_ao_
praos74923563pr_aos
prelaw1139103prelaw
prelim10311423prelim
preload1049813preload
preop94715873pr_eop
presong1039843presong
pretor8315743pretor
prig75924873pr__ig
prill74117943pril_l
prills84015613prills
primo95017913primo_
primos104514423primos
prion75119993pr_ion
prior74316173pr_ior
prison8514023prison
pro55837263pr__o_
proa66229963pr__oa
proas75028803pro_as
probang12278383probang
probe94320813pro_be
probed114114823probed
prober104516073prober
probes104119453probes
probing123314443probing
probit103218353probit
problem1335983problem
proctor11310433proctor
prod76129503pr__od
prodigy1435573prodigy
prodrug1142953prodrug
prods85523553pro_ds
proem94818273pro_em
proems104711163proems
prof96134663pr__of
profit113016273profit
profs105120893pro_fs
progs86624153pro_gs
progun968783progun
projet15315183projet
prolabor1284543prolabor
prolans9314273prolans
prolate9419793prolate
proline92321593proline
prologing1338953prologing
prologist12315083prologist
prologize2147963prologize
prologued1344663prologued
prologues1246903prologues
prolonged13285413prolonged
prolonger12305873prolonger
prolonges12337923prolonges
prom87631703pr__om
promoed12310083promoed
promoing13310463promoing
promote11313143promote
prompt12313013prompt
proms95426413pro_ms
prone75332623pro_ne
prongs94314483prongs
pronota939763pronota
pronoun939033pronoun
pronto8313993pronto
proofs114511683proofs
prop85932813pr__op
propel103714063propel
proper104319953proper
propone112716303propone
propose112714843propose
props95726883pro_ps
propyl13358183propyl
propylon1544873propylon
prorogue1145243prorogue
pros65742783pr__os
prose75835123pro_se
prosed94921093prosed
proser84223463proser
proses84733473proses
prosing103319383prosing
prosit85124593prosit
prosody1336433prosody
prosoma11310223prosoma
pross76529403pro_ss
prost75434103pro_st
prosy106319253pro_sy
protea82214763protea
protege1059153protege
protei82615313protei
protons93118003protons
protyl11308213protyl
proud84615483pro_ud
prove104823193pro_ve
proved125016033proved
proven114314773proven
prover113819723prover
proves114322253proves
proving134214073proving
provoke1676123provoke
provost1238573provost
prow97030383pr__ow
prowar114110943prowar
prower114218123prower
prowl105615123pro_wl
prowled13309903prowled
prowler123310013prowler
prowling1449993prowling
prowls115511083prowls
prows106327013pro_ws
proxy175011013pro_xy
prutot8311823prutot
prying124114803prying
putlogs1065083putlogs
pylon103614003p_ylon
pyrola1139003pyrol_a
pyrolas1239863pyrolas
quohog1942503quohog
robot7325973_robot
role45851823_rol_e
roles56747983_roles
rolf75134873_rol_f
rolfs84817123_rolfs
roll46331653_rol_l
rolls55326233_rolls
rood56733003_ro_od
roof75738833_ro_of
rook85532033_ro_ok
room66235083_ro_om
root45655923_ro_ot
roto45935053_roto_
rotor55519733_rotor
rotos56027883_rotos
sawlog1035793sawlog
serology1238143serology
sholom11910113sholom
slog56728273__slog
solo45538943_solo_
solon55026133_solon
solos54830793_solos
stolon64112073stolon
theolog1146153theolog
tholoi9339233tholoi
tholos94213003tholos
trilogy1136013trilogy
trog57628213tr__og
trogon73611753trogon
troll54416533trol_l
trollop944793trollop
trolls64613943trolls
trolly94012363trolly
troop76417533tro_op
trooz145016153tro_oz
ufology14244563ufology
unclog956603unclog
uproot8314123upro_ot
urologic1147343urologic
uropod937263uropod
virology1545843virology
vroom105312473vro_om
weblog1234223weblog
wrong94712323wro_ng
zoology2036513zoology

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.1231452772.4
2DLD Change Limit1127163535.09622118.5
3Display Results3533530.1063330.2
 (SQL Overall)1786913535.32533557.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.