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

178 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
virosis103902(None) 
viroses10310531viroses
fibrosis1345452fibrosis
hidrosis1246302hidrosis
miosis83615162mi_osis
mitosis939632mitosis
pyrosis12411652pyrosis
sorosis72611962sorosis
vibriosis1443922vibriosis
viroid10411522viro_id
viroids1137922viroids
viruses1039412viruses
xerosis14249662xerosis
abiosis939373abiosis
abrosia939273abrosia
abrosias1049033abrosias
acidosis1146143acidosis
across8312643acros_s
adiposis1146253adiposis
aiolis6316843ai_olis
airposts1045923airposts
amitosis1047203amitosis
ariosi64313033ariosi_
ariosos7409853ariosos
arsis55722423_ar_sis
bigoses1039073bigoses
biros75325133biro__s
birses84717733bir_ses
broses86524403_broses
cirrhosis1442723cirrhosis
cirsoid1038123cirsoid
crasis85020473_crasis
crisis83716343_crisis
cross75124503_cros_s
dieresis956853dieresis
diesis74013493di_esis
diplosis11128413diplosis
diuresis945133diuresis
dross65418093_dros_s
enosis63816423_enosis
eroses65327053_eroses
fibroses1345973fibroses
firsts95110923fir_sts
frosts94214623_frosts
gaposis1038423gaposis
girons75014373giro_ns
giros65722653giro__s
girosol885303girosol
girosols984653girosols
gnosis75711213_gnosis
gross65421693_gros_s
hidroses1237903hidroses
iris45732553_ir__is
irises64221173_irises
iritis63113733_iritis
irokos1037233_irokos
irones64724013_irones
ironic8313773_ironic
ironies7517423_ironies
ironist7314843_ironist
irons55324133_iro_ns
kaross101910013karos_s
kenosis11369003kenosis
ketosis11429733ketosis
kinesis11259593kinesis
kiosks934383ki_osks
kurtosis1294403kurtosis
lordosis944453lordosis
meiosis939023meiosis
merisis93213173merisis
mimesis1137323mimesis
mimosas1136753mimosas
mioses84318853mi_oses
missis84417503mi_ssis
mitoses9312183mitoses
mycosis1437763mycosis
myosis114012563_myosis
narcosis10388043narcosis
necrosis1048883necrosis
nerolis71012773nerolis
neurosis848843neurosis
nigrosin945233nigrosin
nigrosins1044873nigrosins
osmosis976573osmosis
ostosis71310123ostosis
oviposit13375613oviposit
oviposits14503733oviposits
paresis93315093paresis
phimosis1546193phimosis
pirogi9299013pirogi_
pirogies1139423pirogies
proses84733473_proses
prosit85124593_prosit
prosos85718553_prosos
pross76529403_pros_s
psilosis1045123psilosis
ptosis83611823_ptosis
pyosis114012123_pyosis
riboses9310443riboses
riposts9279403riposts
roses56445773__roses
roshis9311793__roshis
rosin55325313__rosin
rosins64521863__rosins
rotis56327053__rotis
saroses73619333saroses
serosas7312663serosas
siderosis1045543siderosis
soroses73117483soroses
sycosis1238813sycosis
tiros54524893tiro__s
trioses75015653trioses
trois57226093_tro_is
vaginosis1343573vaginosis
vamoses1239143vamoses
varicosis1445023varicosis
varooms1248883varooms
varuses10310623varuses
verisms123011253verisms
verists103613673verists
vermis114214963ver_mis
verses94223763ver_ses
versos93812803ver_sos
versts93914733ver_sts
versus94211143ver_sus
vibists1256483vibists
vibrioses1443923vibrioses
vibronic1545133vibronic
vigorish1545173vigorish
vigors102911483vigo_rs
vigours11285483vigours
vinos84723073vino__s
vinosity1445733vinosity
vinous93914173vino_us
violas93713523vi_olas
violin9311983vi_olin
violins10311453vi_olins
violist10312143vi_olist
viols86118103vi_o_ls
viragos1146713viragos
virelais1146413virelais
viremia1246083viremia
viremias1345873viremias
viremic1436153viremic
vireos94212453vir_eos
vires84529683vir__es
virgas1048883vir_gas
virgin1038083vir_gin
virgins1137863virgins
virid94116043vir__id
virilism1347273virilism
virions1039873virions
virls85618603vir__ls
virtues10338023virtues
virtuosas1251953virtuosas
virtuosi1142123virtuosi_
virtuosic1451773virtuosic
virtuosos1251633virtuosos
virtus94310143vir_tus
virus85316843vir__us
virusoid1243183virusoid
virusoids1342483virusoids
visas84317653vi__sas
viscoses1338343viscoses
vises84427773vi__ses
visit8320963vi__sit
visits9311423vi__sits
visors92912223viso_rs
vizors18328903vizo_rs
volosts1036563volosts
vrooms11398713v_rooms
vrouws12494743v_rouws
vrows116115263v_ro_ws
whoosis1335443whoosis
whosis1237163_whosis
xeroses143612823xeroses
zygosis20405953zygosis
zymosis21487493zymosis

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271786.78019768.0
3Display Results1781780.0802225.0
 (SQL Overall)1786911787.01625469.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.