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

139 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
viscoses133834(None) 
viscose1237861viscose_
ciscoes113610732cisco_es
discases112014502discases
discloses1249472discloses
discuses113112862discuses
disposes11313822disposes
miscodes13310422miscodes
viroses10310532vi_roses
viscous1238832visco_us
abscises1246233abscises
asceses938623_asceses
bigoses1039073bi_goses
bioscopes1546553bioscopes
caseoses1039293caseoses
circuses1238253circuses
ciscos104711133cisco__s
cistuses1038283cistuses
coses76949493___coses
cosmoses1239703cosmoses
cuscuses1235863cuscuses
dioceses1137113dioceses
diploses111110323diploses
discase102912863discase_
discased122510853discased
disclose1148743disclose_
disclosed1347363disclosed
discloser1256803discloser
disclosers1375193disclosers
discoed11312483disco_ed
discoids1239873discoids
discords1238593discords
discos94915213disco__s
discourses1346503discourses
discover1439563discover
discovers1538153discovers
discuss10357953discus_s
discusses12268253discusses
diseases92415813diseases
diseuses93112763diseuses
dispose10312763dispose_
disposed12310943disposed
disposer11310413disposer
disposers1238373disposers
disrobes1139743disrobes
disses75225963dis__ses
distomes11314163distomes
disuses84015413dis_uses
disyokes1656503disyokes
episcopes1545803episcopes
fiascoes13134923fiasco_es
fibroses1345973fibroses
ficoes114613463fi_co_es
ficuses12159203fi_cuses
fucoses12148303_fucoses
glucoses1145333glucoses
hidroses1237903hidroses
hisses94719353his__ses
histones11312803histones
icones84616383_i_cones
imposes113213683_imposes
incases93615973_incases
incises93414893_incises
incloses101610533_incloses
incomes11712373_incomes
incuses93514853_incuses
kisses104217333kis__ses
mioses84318853mi__oses
miscasts1238353miscasts
mischooses1744633mischooses
mischose1547263mischose_
mischosen1644003mischosen
miscites12313783miscites
miscode12310413miscode_
miscoded1437983miscoded
miscoins12311083miscoins
miscooks1645463miscooks
miscopies1549613miscopies
miscues11312393misc_ues
misdoes10312493misdo_es
miseases102614343miseases
mismoves1537293mismoves
mispoises1348353mispoises
misses85130873mis__ses
missises103513693missises
missuses10309683missuses
misuses93216023mis_uses
misyokes1735513misyokes
mitoses9312183mi_toses
mycoses1437733_mycoses
narcoses103910543narcoses
osmoses9138123_osmoses
ostoses71213553_ostoses
piscos105112593pisco__s
pishoges1446953pishoges
pisses84525083pis__ses
pistoles102514723pistoles
psiloses1036443psiloses
rescores105415693rescores
riboses9310443ri_boses
rissoles839113rissoles
risuses73210923ris_uses
roscoes9310923rosco_es
scones84521303__scones
scopes104719593__scopes
scores84725923__scores
scouses93313243__scouses
silicoses1186183silicoses
sisses64520603sis__ses
sycoses1249133_sycoses
vamooses1345523vamooses
vamoses1239143v_amoses
varicoses1446653varicoses
viatores11257683viatores
vibrioses1443923vibrioses
vices105725533vi_c__es
vichies15310623vi_chies
vicomtes1545593vi_comtes
villose1038053villose_
vinasses1135703vinasses
violones1137383violones
virosis1039023vi_rosis
viruses1039413vi_ruses
visages1138693vis_ages
viscoid1337023visco_id
viscosities1645093viscosities
viscosity1744113viscosity
viscount1396783viscount
viscounts1484583viscounts
viscously1744853viscously
viscousness1655533viscousness
viscus11428503visc__us
vises84427773vi___ses
visioned1247013visioned
visions10311023visio_ns
visored1138143vis_ored
visors92912223vis_o_rs
vitesses1136333vitesses
wisses94619603wis__ses

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621396.95321021.4
3Display Results1391390.0602316.7
 (SQL Overall)1786911397.46623934.0
 
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.