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

105 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
ormolus93474(None) 
ormolu845831ormolu_
cormous11312352cormo_us
formols12299412formol_s
obolus8378812o_bolus
orioles7412992orioles
osmoles9138362osmoles
osmols8137312osmol_s
osmous8138182osmo_us
amoles84122193_amoles
areolas71013863areolas
areoles71016953areoles
argols74514613argol_s
armfuls1275013armfuls
armholes1347383armholes
armors85017813armo_rs
armour84411853armo_ur
armours9389853armours
awmous1157713awmo_us
bolus79125543__bolus
brumous11107443brumo_us
carolus94612603carolus
comous10816503como_us
cormels113813373cormel_s
creoles9913323creoles
crocus104813173cr_ocus
cumulus1135453cumulus
cymols1377193cymol_s
cymous1388403cymo_us
dormouse1144243dormo_use
drolls75312393dr_olls
drools74412813drool_s
embolus1135543embolus
enormous1046553enormo_us
famous11412393famo_us
famulus1235043famulus
formals123312893formal_s
formol112910333formol__
formulas1346303formulas
formyls15235703formyl_s
fumulus1234443fumulus
grumous1086613grumo_us
hamulus1235323hamulus
hormones13311163hormones
limulus935083limulus
modiolus1143773modiolus
modus85417203__modus
molas75132093__molas
molds85324833__molds
moles74747923__moles
molls75129783__molls
mols65948573__mol_s
molts76032093__molts
momus96116113__momus
normals92510903normal_s
obelus8348403o_belus
oboles83815833o_boles
obols73715863o_bol_s
ocellus935983ocellus
octopus1144813octopus
oculus8178393o_culus
odious749933odio_us
oracles93212423oracles
orals55826483or_al_s
ordos65216203ordo__s
orgones81010793orgones
orgulous944213orgulous
oriels64914623oriel_s
oriole6814293oriol_e
orles55326213or__les
orlons6411013orlo_ns
orlops847303orlo_ps
ormers84316143orm_ers
ortolan747083ortolan
ortolans846553ortolans
orzos143311253orzo__s
osmious936003osmious
osmol7138573osmol__
osmolal944393osmolal
osmolar944483osmolar
osmole8128513osmol_e
osmoses9138123osmoses
osmosis976573osmosis
ovolos9257203o_volos
porous84419483por_o_us
premolds1345843premolds
proles84627203pr_oles
ramous8417113ramo_us
remolds10299703remolds
rimous8311913rimo_us
roles56747983_r_oles
rolfs84817123_r_olfs
rolls55326233_r_olls
smolts84411883_smolts
solus54726983__solus
tolus55024483__tolus
torous64319033tor_o_us
tremolos1046043tremolos
triols66117803triol_s
troilus736413troilus
trolls64613943tr_olls
tumulus935033tumulus
unmolds10135743unmolds
wormholes1744613wormholes
wormils1236733wormil_s

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.390458182.1
2DLD Change Limit1340271056.47020715.1
3Display Results1051050.0462282.6
 (SQL Overall)1786911056.90625874.7
 
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.