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

157 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
ostioles83927(None) 
ostiole739011ostiole_
hostiles11312212hosti_les
orioles7412992o_rioles
osmoles9138362os_moles
ossicles1054182ossicles
osteoses839032osteoses
ostiolar844582ostiolar
ostoses71213552ost_oses
outsoles8813112outsoles
petioles10311642petioles
postholes14410452postholes
stifles103013392_stifles
stiles64328772_sti_les
stoles63927672_st_oles
antipoles11810473antipoles
apostilles1244043apostilles
articles10310243articles
assholes1146743assholes
astilbes1044733astilbes
bastiles10313353basti_les
bastilles1147353bastilles
boltholes1445723boltholes
carioles10817073carioles
citoles9312553cit_oles
cuticles1237893cuticles
darioles9710693darioles
entitles8710663entitles
estriols856253estriol_s
estrones8313323estrones
etoiles7411293_etoiles
fetiales11319613fetiales
hostile10312553hosti_le_
intitles8710003intitles
istles62814983ist__les
jostles143411143jost__les
mistitles1147953mistitles
motiles93317433moti_les
oboles83815833o__boles
obstacles1343713obstacles
octuples1244133octuples
oestriols944333oestriol_s
oestrones949773oestrones
oilholes1146153oilholes
optimes1148473opti_mes
optioned1146383optioned
optionee1046513optionee
optionees1144343optionees
options93810603optio_ns
oriole6814293o_riole_
orthoses11311133orthoses
oscines9310363osci_nes
oscules938123os_cules
osmious936003osmio_us
osmole8128513os_mole_
osmols8137313os_mol_s
osmoses9138123os_moses
ossicle944483ossicle_
ossifies1177563ossifies
osteoids945953osteoids
osteomas1045333osteomas
osteosis846743osteosis
ostiaries948803ostiaries
ostler63312193ost__ler
ostlers72911203ost__lers
ostomies10310583ostomies
ostosis71310123ost_osis
ostriches1446633ostriches
otiose639403o_tiose_
outboxes1737823outboxes
outcomes1239763outcomes
outdoes8313123outdo_es
outfoxes1836743outfoxes
outgoes8312643outgo_es
outloves11249673outloves
outmodes11208963outmodes
outmoves13228173outmoves
outpolls1046213outpolls
outrolls847823outrolls
outsole71013433outsole_
outvotes1137903outvotes
outwiles1139233outwiles
ovarioles1244603ovarioles
pastilles1148703pastilles
pestholes1448233pestholes
petiole9311303petiole_
petioled1137993petioled
pistoles102514723pist_oles
portholes14410373portholes
posoles9314883pos__oles
postboxes2045243postboxes
postcodes1446153postcodes
posthole1339533posthole_
postiches1648223postiches
posties93128813posti__es
postiques2045833postiques
postpones1348833postpones
postposes1348193postposes
potholes13312933potholes
ratholes11312413ratholes
reticles103912483reticles
retiles74426993reti_les
retitles83612593retitles
rutiles74315843ruti_les
sidles74721153_s_idles
smiles84522293_smi_les
soles55547923_s__oles
sotols63714473sot_ol_s
spiles84227913_spi_les
stables93219073_stables
stales65538293_st_ales
staples93617213_staples
steles63725663_st_eles
stickles142512103_stickles
sties55132983_sti__es
stifle93611903_stifle_
stifled113511093_stifled
stifler102911473_stifler
stiflers11238833_stiflers
stile54931573_sti_le_
stilled83314783_stilled
stiller73414293_stiller
stillest8311073_stillest
stills64118573_sti_lls
stilts67915313_sti_lts
stimes85920573_sti_mes
stimies9316563_stimies
stipels9418953_stipels
stipes84524053_sti_pes
stipples1247023_stipples
stipules1037053_stipules
stirpes95011293_stirpes
stokes104821793_st_okes
stole54928813_st_ole_
stoled74521593_st_oled
stolen64315063_st_olen
stones65130033_st_ones
stooges83611483_stooges
stooled84313893_stooled
stoolies8311083_stoolies
stools65117023_stool_s
stopes84525893_st_opes
stores65533663_st_ores
stoves93818923_st_oves
strobes93813263_strobes
strokes114316323_strokes
strolls739183_strolls
styles94418653_st_yles
swiples12339643_swiples
systoles1146483syst_oles
testicles1146773testicles
tholes94919783__tholes
tiles55542103__ti_les
titles63719923__titles
toiles63923513__toiles
toles55147133__t_oles
varioles11711123varioles

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621576.51622431.2
3Display Results1571570.0632492.1
 (SQL Overall)1786911576.73226543.5
 
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.