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

107 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
osmious93600(None) 
osmous8138181osm_ous
nimious937662nimious
obvious1244822obvious
odious749932o_dious
ominous949032o_minous
osmics1036462osmi_cs
osmium1036572osmi_um
osmiums1134142osmiums
osmols8137312osm_ols
osseous736052osseous
simious939802simious
amicus103810003_amicus
anxious1437283anxious
awmous1157713awm_ous
bilious9310933bilious
camions113916133camions
carious93320283carious
comous10816503com_ous
conscious1347593conscious
copious11311963copious
cormous11312353corm_ous
cosmids1237633cosmi_ds
cosmisms1446223cosmisms
cosmists1237993cosmists
cosmos10311753cosm_o_s
curious93813563curious
cymous1388403cym_ous
devious1138523devious
dubious1036893dubious
envious1037223envious
estrous7712533estrous
eximious1743873eximious
famous11412393fam_ous
fashious1446123fashious
folious103710733folious
furious103110633furious
gummous1236263gummous
impious1137063impious
laminous1037953laminous
luminous1037113luminous
luscious1044853luscious
meous76120063__meous
miaous8511693__miaous
minus75223933__minus
noxious1446563noxious
numinous1046293numinous
ochrous1237943ochrous
odorous837663odorous
oestrous869923oestrous
olios54520853o_lio_s
omits75018263o_mi_ts
omnibus1152983omnibus
onerous7312973onerous
onions64016433o_nions
oomiacs1135683oomiacs
oomiaks1344123oomiaks
options93810603options
ormolus934743ormolus
oscines9310363oscines
osiers63412793os_iers
osmic939913osmi__c
osmol7138573osm_o_l
osmole8128513osm_ole
osmoles9138363osmoles
osmose8108003osm_ose
osmoses9138123osmoses
osmosis976573osmosis
osmunds1042883osmunds
ostiole739013ostiole
ostioles839273ostioles
ostium8310133osti_um
ozonous1645263ozonous
pious74621273__pious
pompous1338063pompous
ramous8417113ram_ous
rimous8311913rim_ous
rosinous847373rosinous
rubious938283rubious
sajous13310583_sajous
sanious7514103sanious
scions82612243_scions
serious73616283serious
serous65023563_serous
setous64917373_setous
sinus55523853_s_inus
situs55019233_s_itus
smiles84522293_smiles
smirks124910123_smirks
smites83921923_smites
smiths114711023_smiths
smogs85112163_sm_ogs
solidus8338113solidus
solions7513753solions
sombrous1246613sombrous
somites94219123somites
soukous1136413soukous
sous46947213_s__ous
spinous9310443_spinous
tedious838443tedious
timeous938403timeous
tortious839023tortious
usurious845273usurious
various103113103various
vicious1239493vicious
vomitous13215803vomitous
vomitus12215743vomitus

Search took 10 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.796224486.2
2DLD Change Limit1340271078.47015823.7
3Display Results1071070.0333242.4
 (SQL Overall)1786911079.29919216.2
 
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.