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

445 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
ologies861502(None) 
oologies9312991oologies
apologies12311192apologies
biologies12311182biologies
bogies94724312_bogies
boogies103719012boogies
colognes11310602colognes
colonies103620012colonies
dogies85022252_dogies
ecologies12312352ecologies
elegies81312902elegies
enologies10312982enologies
eulogies938522eulogies
fogies104118062_fogies
geologies11410642geologies
glories81915912glories
loges66534202_log_es
logics95711122_logics
logier75015732_logier
logiest82515542_logiest
logins77820642_logins
longies82916552longies
loobies93814102loobies
looies65025832_looies
loonies73919542loonies
lories64933042_lories
louies64525102_louies
myologies1539752myologies
neologies10411712neologies
noogies82814582noogies
oldies7314422ol_dies
ologist8313832ologist
ologists939442ologists
orgies72316092o_rgies
orologies10311622orologies
otologies10311402otologies
pogies94123542_pogies
stogies8413692stogies
ufologies1345982ufologies
urologies1039532urologies
zloties1639912zloties
zoologies1939012zoologies
aerologies11312023aerologies
aggies83515513_aggies
agonies83016623agonies
agrologies1237693agrologies
algins74816433al_gins
algologies1246793algologies
alibies9313323alibies
alkies104518093al_kies
allies63827673al_lies
aloes54933673alo__es
aloins65022203alo_ins
analogies101910643analogies
anomies93316993anomies
apiologies1339063apiologies
apogees1037103apogees
apologias1247503apologias
apologise1248303apologise
apologises1347303apologises
apologizes2246203apologizes
apologues1245023apologues
areologies1139823areologies
atomies93918363atomies
atonies75320953atonies
atopies92816433atopies
axiologies1837483axiologies
baggies113814853baggies
biggies113813523biggies
biologics1446863biologics
blogger11448313blogger
bloggers12397403bloggers
blogs85319233blog__s
blokes123813883blo_kes
blondes104213163blondes
bloodies11310163bloodies
blooie83913193blooie_
blouses94014463blouses
blowier1248943blowier
blowiest1337923blowiest
bodies94524143_bodies
bogie89524103_bogie_
bogles95020833_bogles
bolognas1144073bolognas
bolshies1338693bolshies
boobies113718203boobies
boodies103721443boodies
boogie93515993boogie_
boogied11379283boogied
bookies133819403bookies
boonies93422483boonies
booties94124613booties
bougies103715183bougies
brogues10719823brogues
bryologies1646043bryologies
budgies115312513budgies
buggies114613813buggies
calories102919553calories
cetologies13410853cetologies
claries93422203claries
clergies1137903clergies
cloches144113713cloches
clogged12528653clogged
clogger11438803clogger
cloggers12437283cloggers
cloggier1244253cloggier
cloggiest1334723cloggiest
clogs85519553clog__s
clones84526563clo_nes
cloques18268563cloques
closes85425593clo_ses
clothes124513813clothes
cloves114918823clo_ves
clozes174915563clo_zes
colies84837053_colies
collies94326583col_lies
collogues1246213collogues
cologne1039363cologne_
cologned1237153cologned
cologs96517353colog__s
colones96124433colo_nes
colonics123711613colonics
colonise102514283colonise
colonises112814013colonises
colonizes202613183colonizes
colorizes203014523colorizes
conies84338593_conies
cookies133719273cookies
coolies93824963coolies
cooties93725733cooties
copies104130303_copies
corodies11313693corodies
cosies84932153_cosies
cozies174521413_cozies
cronies9622503cronies
cytologies1639263cytologies
dingies93618243dingies
dobies94422093_dobies
doges75630163_dog_es
doggies103613023doggies
dogie75222793_dogie_
dollies83620983dol_lies
dolomites1248083dolomites
doobies103915673doobies
doodies94218773doodies
doolies83920713doolies
doozies173812723doozies
dories75232363_dories
doxies143917853_doxies
doxologies1946323doxologies
drogues9398393drogues
duologues1143393duologues
ebonies9312883ebonies
eclogites1245263eclogites
eclogues1144573eclogues
elegise8139393elegise
elegises9128823elegises
elegits8149343elegits
elegizes18137103elegizes
eloigns8425353eloigns
eloins65419383elo_ins
elopes85918163elo_pes
eolopiles1145823eolopiles
epoxies1637753epoxies
ethologies14310543ethologies
etiologies1139413etiologies
eulogias946553eulogias
eulogise945643eulogise
eulogises1045683eulogises
eulogizes1945593eulogizes
felonies11310993felonies
fetologies1439183fetologies
flies85630713fl__ies
floes85528143flo__es
flogged13528803flogged
flogger12449463flogger
floggers13387863floggers
flogs95919963flog__s
flooie93712153flooie_
floosies113210233floosies
floozies20326953floozies
floppies1546813floppies
florins10311643florins
flosses103411973flosses
flossies112810123flossies
fogie96719003_fogie_
folkies143612253fol_kies
follies103618943fol_lies
foodies113416753foodies
footies103721543footies
gemologies1449003gemologies
geologizes2146793geologizes
gies55641423___gies
globes94314543glo_bes
globins10278953globins
gloggs935033glog_gs
glorias81610323glorias
gloried9169513gloried
glosses84014123glosses
glossies93311253glossies
gloves104115183glo_ves
glozes164313353glo_zes
gobies95418063_gobies
goloshes1236253goloshes
goodies93516993goodies
googlies1086763googlies
goonies83618333goonies
hoagies112811993hoagies
hogties112813993_hogties
holies94630033_holies
hollies103420813hol_lies
hologamies1645873hologamies
hologynies1744353hologynies
homies114524723_homies
homologies16311523homologies
hongies112716473hongies
hoodies113419833hoodies
hookies144017443hookies
horologies14411053horologies
ideologies1237333ideologies
illogics1144593illogics
ironies7517423ironies
isologues1044563isologues
ivories10310713ivories
jaggies163311083jaggies
jalopies1786673jalopies
jollies143516273jol_lies
kluges11389573klug_es
ladies75124883_ladies
lazies154418783_lazies
leges64427293_leg_es
legits71313003_legits
levies93919863_levies
lies46454193_l__ies
lilies63021413_lilies
loaves94813853_loaves
lobbies113612463lobbies
lobes75331003_lo_bes
locoes85516583_locoes
lodes66436913_lo_des
lodges86820153_lodges
logans76319063_logans
loge56837193_log_e_
logged96622943_logged
logger86420003_logger
loggers94616133_loggers
loggets9378913_loggets
loggias9356783loggias
loggie84011993loggie_
loggier93811143loggier
loggiest103011013loggiest
logia68116603_logi_a
logic88217833_logi_c
logily1039833_logily
login66025003_logi_n
loginess9310163_loginess
logion76013723_logion
logions86211293_logions
logons79818173_logons
logos67225333_log_os
logs57343113_log__s
loids66220703_lo_ids
loins56728423_lo_ins
lollies73116923lollies
longes75925573_longes
looie55624243_looie_
loonie64216453loonie_
loonier73312683loonier
looniest83313253looniest
loopier93711193loopier
loopiest103011313loopiest
looses67328243_looses
lopes76437343_lo_pes
lores55045403_lo_res
loris55329153_lori_s
lorises73918593_lorises
lorries74518343lorries
loses56742013_lo_ses
losses65925233_losses
lottes65322753_lottes
louie55023513_louie_
louis57322323_loui_s
loupes84918053_loupes
louses66230283_louses
loves85332013_lo_ves
lowes85732463_lo_wes
loxes125227473_lo_xes
luges65928753_lug_es
luggies93011213luggies
lunies64723013_lunies
melodies11310123melodies
menologies13310603menologies
misologies13139063misologies
mixologies20136583mixologies
moggies113111723moggies
molies84429513_molies
mollies93420233mol_lies
monies83233163_monies
monodies11312503monodies
monologies13312543monologies
movies115118453_movies
moxies154317403_moxies
mycologies1848863mycologies
myopies14309723myopies
neologizes2047243neologizes
nobodies1137293nobodies
nomologies1339473nomologies
noogie73612313noogie_
nookies113414963nookies
nosologies1148103nosologies
obligees1143953obligees
obliges1037143oblig_es
obloquies2042773obloquies
oboes75717713obo__es
oboles83815833obo_les
odorizes1837213odorizes
oecologies1339463oecologies
oenologies1139393oenologies
ogees65119143__ogees
ogives10367913__ogives
ogles65223183__ogles
ogres65818633__ogres
oinologies1148303oinologies
oldie6415473ol_die_
oldwives1542463oldwives
oleates7417833oleates
olefines1137323olefines
olefins1037493olefins
oleines7313393oleines
oleins6313523ol_eins
oles46453473ol___es
olios54520853ol__ios
olives94313953ol_ives
olivines1137473olivines
ology94113113olog__y
oncologies1348653oncologies
ontologies1139883ontologies
oodles73517183o_odles
oogamies1147413o_ogamies
oogenies9311583o_ogenies
oolites72817843oolites
oologic1049423oologi_c
oologist9313493oologist
oologists1039853oologists
oorie53026363o_orie_
ootids71110353o_otids
oozes145418713o_o_zes
oozier153610253o_ozier
ooziest163411523o_oziest
orgones81010793orgones
origins8310463origins
orogenies10410533orogenies
oroides8311973oroides
ostomies10310583ostomies
otalgies936393otalgies
outgives12218623outgives
outgoes8312643outgoes
outlies72421993outlies
outvies102214243outvies
ovaries10312653ovaries
ovoids10456923ovo_ids
ovonics12245553ovonics
ozones1539393ozo_nes
ozonides1854293ozonides
ozonise1646443ozonise
ozonises1776373ozonises
ozonizes1636083ozonizes
pedologies1439343pedologies
penologies13311233penologies
peonies93620153peonies
phonies123717513phonies
piggies113813483piggies
pirogies1139423pirogies
plages94520153plag_es
plagues103311063plagues
platies93722543platies
plies74526513pl__ies
ploidies1138173ploidies
plosives1335893plosives
plotties103111413plotties
plotzes18317703plotzes
pokies125921333_pokies
policies122415663policies
polies84034583_polies
polities102722343polities
pomologies15310043pomologies
ponies84833463_ponies
porgies103017003porgies
posies84431433_posies
posologies1349543posologies
prologizes2248113prologizes
prologues1246903prologues
proxies163014933proxies
pyrologies16310013pyrologies
raggies93214733raggies
rheologies1488433rheologies
rogues74617673_rogues
roofies103014413roofies
rookies113917103rookies
roomies93017243roomies
serologies11311333serologies
sexologies1837713sexologies
shogis103810943shogi_s
sinologies1148893sinologies
sitologies1148703sitologies
sloes54728873slo__es
slogans8407983slogans
slogged104910473slogged
slogger94310483slogger
sloggers10418783sloggers
slogs64521843slog__s
sloids73712693slo_ids
slopes84820453slo_pes
sloshes103811803sloshes
sodomies11128553sodomies
stogie7311323stogie_
stories7324273stories
theologies141010103theologies
tobies84521023_tobies
tocologies1349763tocologies
todies74223553_todies
togues76014243_togues
tokologies1547143tokologies
toonies73719883toonies
topologies1348973topologies
tories65435883_tories
towies93521193_towies
trilogies1048173trilogies
typologies1647643typologies
veggies1237553veggies
vegies104314273_vegies
venologies1438373venologies
virologies1447213virologies
vogie95116663_vogie_
vogues104011923_vogues
voleries11313233voleries
wedgies123910213wedgies
woodies113517153woodies
woolies104117363woolies
woollies1147413woollies
yogees10510633_yogees
yogins105114103_yogins
yogis95617743_yogi_s
yowies123913733_yowies
zymologies2546413zymologies

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 Filter1786911340270.410435831.7
2DLD Change Limit1340274456.13621842.7
3Display Results4454450.1562852.6
 (SQL Overall)1786914456.70226662.3
 
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.