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

309 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
oolith9381324(None) 
eolith93013901eolith
oolite63319601oolite
ooliths10268321ooliths
otolith10108281otolith
coolish12312522coolish
coolth1139512cool_th
eoliths10318572eoliths
foolish1339612foolish
goliath1145932goliath
iolite63221972iolite
monolith1349672monolith
neolith1068782neolith
oolites72817842oolites
oolitic92512882oolitic
otoliths11104512otoliths
owlish1238692owlish
polish114916722polish
polite83625072polite
polity113015862polity
urolith1048782urolith
abolish12311503abolish
acrolith1348453acrolith
aerolith1149833aerolith
alit46155693_alit_
aplite8316393aplite
baith108023133_baith
blite76225353_blite
blithe115810863_blithe
blitz165318133_blitz
boite74426323bo_ite
bolete8519613bolete
boleti8413403boleti
bolide9515563bolide
bolt66254173bol_t_
bolts76232113bol_ts
bonita8312943bonita
bonito8313433bonito
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
booth105522013bo_oth
both96533433bo__th
boyish142911233boyish
brith104924373_brith
caliph13311403caliph
cloth105817543_cloth
coccolith1544413coccolith
cogito939203cogito
coldish1399303coldish
colic95726173coli_c
colics104219903colics
colies84837053colies
colin76231693coli_n
colins85229043colins
colitic112916183colitic
colitis92617343colitis
colt67158243col_t_
coltish121310933coltish
colts76633293col_ts
cometh134811683cometh
comity13312713comity
coolie83821603cooli_e
coolies93824963coolies
cooling103422573cooling
coolths1236013cool_ths
couth106122483co_uth
coyish143710393coyish
daleth1038633daleth
delish105215613delish
doeth9411983do_eth
doit56347853do_it_
doits66223673do_its
doling84923133doling
dollish11610093dollish
dolt56649423dol_t_
doltish11118733doltish
dolts65626313dol_ts
doolie73916833dooli_e
doolies83920713doolies
doth86225713do__th
dovish1338103dovish
elite56230183_elite
eolian6312593eolian
eolithic1375853eolithic
faith115620853_faith
filth115015823fil_th
flit76539273_flit_
flitch14928173_flitch
flite85424963_flite
flits85625223_flits
folate93320393folate
folia83618933foli_a
foliar93210973foliar
foliate10513533foliate
folic105319323foli_c
folio83820883foli_o
folios93915463folios
folium11310453folium
folkish1736563folkish
fomite113314073fomite
foolfish1744393foolfish
fooling113117373fooling
forth116222673fo_rth
fourth12357443fourth
frith115922033_frith
glitch12286353_glitch
glitz154916373_glitz
goliaths1244223goliaths
golosh1036463golosh
goodish1237963goodish
goth86825083go__th
goyish13379013goyish
grith95520373_grith
hadith13312063hadith
halite93624233halite
holier94921623holier
holies94630033holies
holily123612953holily
holing104025073holing
holism113713743holism
holist94723213holist
holists104413963holists
holt77852583hol_t_
holts85627913hol_ts
hoolie93217773hooli_e
hoplite12311073hoplite
illite63414913illite
iolites73819483iolites
jollity1746143jollity
jolt116639123jol_t_
jolts125018883jol_ts
jolty155713033jol_ty
kaliph1537873kaliph
kith115826353__kith
kryolith1843213kryolith
laith85722103_laith
lath76640383__lath
lich96230843__lich
lit39377313__lit_
lite47054543__lite
lithe84922013__lithe
litho86513783__litho
lits46252493__lits
litu47631563__litu
loath84918603lo_ath
loth76132133__loth
lowish12310533lowish
modish123813543modish
molies84429513molies
moline84422033moline
mollah11319453mollah
moloch1356483moloch
molt66356163mol_t_
molto75619603mol_to
molts76032093mol_ts
monish114217593monish
monoliths1445913monoliths
month104818423mo_nth
moolah11409193mool_ah
moonish123311043moonish
moonlit9229333moonlit_
moorish123311783moorish
mopish134311593mopish
moth96731333mo__th
mouth105420293mo_uth
mulish11311903mulish
neoliths1144933neoliths
norite63221133norite
north86018273no_rth
oafish121311723oafish
oath76132153_o_ath
obit66837073_obit_
obits74617543_obits
oblate82214743oblate
oblige937653oblige
oboli73712873oboli__
oddish11107653oddish
oddity1135243oddity
offish15137273offish
ogling83211883ogling
ogrish1039263ogrish
oilier64417233oilier
oilily93111723oilily
oiling74925313oiling
oldish10169313oldish
olio46829673_oli_o
olios54520853_olios
olive84817153_olive
omit65337363_omit_
omits75018253_omits
online6315843online
oocyte1135753oocyte
oodlins83210513oodlins
ooh67637093oo___h
oohing104412933oohing
oology103210253oology
oolong738073oolong
oomiac1037063oomiac
oomiak1235353oomiak
oompah1334253oompah
oomph1236973oo_mph
oorie53026363oori_e
oot311274693oo__t_
ootid61416693ooti_d
ootids71110353ootids
oots46446443oo__ts
oozier153610253oozier
oozily18328073oozily
oozing163812203oozing
ophite11410563ophite
orality101111683orality
orbit73622053orbit_
orbits84211433orbits
otolithic1443393otolithic
outwith13279133outwith
ovality1377593ovality
ovoli8358283ovoli__
owlet83324463owlet_
owlets93110393owlets
oxlike17307473oxlike
oxlip1456883oxli_p
oxlips1544433oxlips
palish114718273palish
pelite84323003pelite
pisolith1346553pisolith
pith95432693__pith
plinth11310453_plinth
podite93315353podite
police102918563police
policy133211513policy
polies84034583polies
poling93526503poling
polio75722553poli_o
polios84019723polios
polis74731163poli_s
politer92417073politer
politic112918713politic
pooling103219093pooling
poorish123712303poorish
poortith1355363poortith
popish133812113popish
posit75833333posit_
posits85718713posits
regolith1247543regolith
relish93916953relish
relit55340683relit_
routh86423073ro_uth
rowth115713233ro_wth
saith85826553_saith
sith75435153__sith
slit46250103_slit_
slits56128853_slits
sloth85019443_sloth
smith107818043_smith
solate64526073solate
soli46637003soli__
solid65025073soli_d
solidi73813153solidi
solids74116403solids
soling74226823soling
solion6616383solion
soliton7410233soliton
solute64016663solute
somite84519373somite
sooth85924053so_oth
sopite84917713sopite
soth75932513so__th
south85223573so_uth
spilth11469733spilth
split75729013split_
splits85416413splits
swith115917403_swith
tallith102913063tallith
tilth85515363til_th
toit46353063to_it_
toits55327473to_its
toling73926123toling
tonish93415903tonish
tooling82918313tooling
tooth88020183to_oth
toroth95512963toroth
toyish122911123toyish
trilith10310513trilith
unlit55025463unlit_
uplit76020803uplit_
uroliths1154923uroliths
voling103918023voling
volt76439533vol_t_
volta85215623vol_ta
volte85321303vol_te
volti84915963vol_ti
volts85421293vol_ts
volute93912763volute
vomit102622573vomit_
vomito11238033vomito
vomits112610923vomits
with105730473__with
wolfish1636933wolfish
woolie93514483wooli_e
woolier103612353woolier
woolies104117363woolies
worth117120523wo_rth
wraith1258603wraith
xenolith1845653xenolith
youth115315043yo_uth
zenith1839073zenith
zeolite1638903zeolite
zizith1744823zizith

Search took 8 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.1401276364.3
2DLD Change Limit1127163097.51614996.8
3Display Results3093090.1062915.1
 (SQL Overall)1786913097.76223021.3
 
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.