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

189 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
ooliths1026832(None) 
eoliths10318571eoliths
oolites72817841oolites
oolith93813241oolith_
otoliths11104511otoliths
colitis92617352colitis
coolths1236012cool_ths
eolith93013902eolith_
goliaths1244222goliaths
iolites73819482iolites
monoliths1445912monoliths
neoliths1144932neoliths
oolite63319602oolit_e
oolitic92512882oolitic
otolith10108282otolith_
uroliths1154922uroliths
acroliths1445113acroliths
aeroliths1245643aeroliths
aplites9314933aplites
blites84721213_blites
blithe115810863_blithe
boites84322703bo_ites
boletes9316063boletes
boletus948643boletus
bolides10515073bolides
bolts76232113bol_t_s
bonitas939453bonitas
bonitos939733bonitos
booths115313793bo_oths
briths115113863_briths
caliphs1436753caliphs
cloths115512483_cloths
coccoliths1652873coccoliths
cogitos1037613cogitos
coitus8511893co_itus
colics104219903coli_cs
colies84837053coli_es
colins85229043coli_ns
colitic112916193colitic
colpitis1247503colpitis
coltish121310933coltish
colts76633293col_t_s
coolies93824963cooli_es
coolish12312523coolish_
coolth1139513cool_th_
couths115715413co_uths
coxitis16238463coxitis
daleths1135323daleths
doits66223673do_it_s
doltish11118733doltish
dolts65626313dol_t_s
doolies83920713dooli_es
elites66027123_elites
eolithic1375853eolithic
faiths124610273_faiths
filths12389783fil_ths
flites95122443_flites
flits85625223_flit_s
folates103218453folates
foliates11412753foliates
folios93915463foli_os
folious103710733folious
foliums1237173foliums
fomites123613203fomites
foolish1339613foolish_
fourths13374953fourths
friths124313583_friths
goliath1145933goliath_
goths96513003go__ths
griths105211653_griths
hadiths1436023hadiths
halites103221193halites
halitus10339963halitus
holies94630033holi_es
holisms123811113holisms
holists104413963holists
holts85627913hol_t_s
hoplites13310543hoplites
illites72415013illites
iolite63221983iolit_e
jolts125018883jol_t_s
kaliphs1634293kaliphs
kiths125814973__kiths
kryoliths1942233kryoliths
laths86022403__laths
litas54923773__litas
lithe84922013__lithe
litho86513783__litho
lithos94212553__lithos
lits46252493__lit_s
molies84429513moli_es
mollahs12328283mollahs
molochs1435223molochs
molts76032093mol_t_s
monolith1349673monolith_
months113812933mo_nths
moolahs12347383mool_ahs
moths106021553mo__ths
mouths115214533mo_uths
neolith1068783neolith_
norites74018803norites
norths96812323no_rths
oaths86117313_o_aths
obits74617553_obit_s
oblates91913243oblates
obliges1037143obliges
olios54520853_oli_os
olives94313953_olives
omits75018263_omit_s
oocytes1246063oocytes
oodlins83210513oodli_ns
oohs75220693oo___hs
oolongs845953oolongs
oomiacs1135683oomiacs
oomiaks1344123oomiaks
oompahs1434263oompahs
oomphs1344723oo_mphs
ootids71110353ooti_ds
oots46446443oo__t_s
ophites12310103ophites
orbits84211443orbit_s
ornithes1136423ornithes
otitis63612343_otitis
otolithic1443393otolithic
owlets93110393owlet_s
owlish1238703owlish_
oxlips1544433oxli_ps
pelites93821993pelites
pisoliths1443643pisoliths
piths105817543__piths
plinths1236123_plinths
podites103014733podites
polices113118053polices
polies84034583poli_es
polios84019723poli_os
polis74731163poli__s
polish114916723polish_
polishes13711783polishes
polite83625073polit_e
politer92417073politer
politest10312943politest
politic112918713politic
politics122513813politics
polities102722343polities
polity113015863polit_y
poortiths1442723poortiths
posits85718713posit_s
regoliths1344113regoliths
rouths95416823ro_uths
rowths12458173ro_wths
slits56128853_slit_s
sloths94911893_sloths
smiths114711023_smiths
solates73523853solates
solids74116403soli_ds
solidus8338113solidus
solions7513753solions
soliton7410233soliton
solitons849593solitons
solutes73515263solutes
somites94219123somites
sooths95715593so_oths
sopites93817173sopites
sorites73825243sorites
soths86218633so__ths
souths95216603so_uths
spilths12356023spilths
splits85416413split_s
talliths11377433talliths
tilths9459373til_ths
toits55327473to_it_s
toolings9248473toolings
tooths96013803to_oths
triliths1145953triliths
urolith1048783urolith_
velites103417303velites
voltes94915583vol_tes
volts85421293vol_t_s
volutes102710983volutes
vomitos12217103vomitos
vomits112610923vomit_s
vomitus12215743vomitus
woolies104117363wooli_es
worths127812893wo_rths
wraiths1355033wraiths
xenoliths1943313xenoliths
youths124510043yo_uths
zeniths1935153zeniths
zeolites1738383zeolites

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.406440125.6
2DLD Change Limit1340271896.06322105.7
3Display Results1891890.0603150.0
 (SQL Overall)1786911896.52927368.8
 
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.