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

413 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
viruses103941(None) 
varuses10310621varuses
viroses10310531viroses
airbuses1067072airbuses
birses84717732bir_ses
ceruses93716232ceruses
circuses1238252circuses
citruses1037482citruses
cruses88127712_cruses
disuses84015412disuses
druses75517252_druses
ficuses12159202ficuses
irises64221172_irises
minuses93512702minuses
misuses93216022misuses
niduses837012niduses
overuses11312642overuses
peruses94018162peruses
risuses73210922risuses
ruses56136582__ruses
sinuses73011592sinuses
situses72710492situses
uruses63616502_uruses
venuses103111412venuses
verses94223762ver_ses
vires84529682vir__es
virgules1244332virgules
virosis1039022virosis
virtues10338022virtues
virus85316842viru__s
vises84427772vi__ses
xeruses143010752xeruses
abuses85119103_abuses
accuses114112193accuses
airbusses1153613airbusses
airless73712043airless
amuses85117943_amuses
animuses1037983animuses
ankuses1148203ankuses
anuses66218773_anuses
arcuses94814693arcuses
arguses84711743arguses
arises65233803_arises
arouses74921293arouses
arrases71214543arrases
arrises71617583arrises
arses55733873_ar_ses
bemuses1139293bemuses
biases84618433bi_ases
biasses94911653biasses
bigoses1039073bigoses
birches143412323birches
birdies104016213birdies
biremes1138773biremes
birkies133712433birkies
birles84920643bir_les
birse74517403bir_se_
bises75435623bi__ses
blouses94014463blouses
boluses94113833boluses
bonuses94212953bonuses
bourses94014303bourses
bouses84931783_bouses
brises84927613_brises
brisses94314313brisses
broses86524403_broses
bruises93212913_bruises
brumes106417073_brumes
brushes124014663_brushes
brutes86118683_brutes
bruxes154811023_bruxes
burses84425513bur_ses
buses75936013__buses
carouses10614503carouses
carses85233653car_ses
causes88026473_causes
cayuses12188403cayuses
cereuses1049243cereuses
cerises94722253cerises
ceruse83914523ceruse_
chiauses1336483chiauses
choruses1339983choruses
chouses125117813chouses
circles1139903circles
cires74932913cir__es
cirques1836463cirques
cistuses1038283cistuses
clauses93813323clauses
coituses1039623coituses
cornuses10310033cornuses
corpses113913803corpses
corpuses12310063corpuses
corses84433463cor_ses
courses94218893courses
crases85532313_crases
crises84529433_crises
cruces105117543_cruces
crudes96218623_crudes
cruises93514443_cruises
cruse75726103_cruse_
cruset84425093_cruset
crusets93811043_crusets
crushes124215133_crushes
crusts84916543_crusts
cruxes154911563_cruxes
curses85328273cur_ses
cypruses1534313cypruses
defuses114814593defuses
diereses938693diereses
dieses75218693di_eses
diffuses1534823diffuses
dilutes82911963dilutes
dinguses1037643dinguses
dirges84915103dir_ges
dirties83119383dirties
discuses113112863discuses
diseuses93112763diseuses
disses75225963di_sses
disuse74012843disuse_
disused93211023disused
diureses936453diureses
divulses1244763divulses
douses74928933_douses
drupes94912653_drupes
druse64817663_druse_
dufuses11436593dufuses
effuses1335903effuses
erases64425403_erases
eroses65327053_eroses
erses55826803_er_ses
estruses838483estruses
excuses1638903excuses
favuses1336183favuses
ferules103112723ferules
fetuses10310243fetuses
fibroses1345973fibroses
figures11239103figures
finises10312903finises
fiques1837973fiqu_es
fires85740753fir__es
firsts95110923fir_sts
fixures17596063fixures
focuses12159653focuses
frises94124273_frises
fucuses12158353fucuses
fuses85628423__fuses
genuses83510883genuses
gigues8128993gigu_es
girdles92210003girdles
girlies83013703girlies
girshes11248293girshes
gorses74723293gor_ses
grilses8319153grilses
grouses84616543grouses
grues65721963_gru_es
grumes94415553_grumes
gyrases11368313gyrases
hiatuses1135773hiatuses
hidroses1237903hidroses
hirees95117293hir_ees
hires86134343hir__es
hirples12149643hirples
hirsel9138683hir_sel
hirsels10128343hir_sels
hirsles101510073hirsles
hisses94719353hi_sses
hocuses121710423hocuses
horses94729343hor_ses
houses96032273_houses
humuses1237593humuses
ibises83610543_ibises
ictuses938293ictuses
ileuses738673ileuses
incuses93514853incuses
infuses102711873infuses
inrushes1136273inrushes
inures63318953_inures
irades74517393_irades
ires45639283_ir__es
irides74519123_irides
irised73913153_irised
irones64724013_irones
issues648803_issues
kinases113511123kinases
kineses113111253kineses
kirmess13234313kirmess
kirtles11309663kirtles
kisses104217333ki_sses
krises105016083_krises
liaises7311053liaises
ligases82310703ligases
ligules82210913ligules
ligures8269883ligures
limbuses1234903limbuses
lipases9209483lipases
litmuses1044463litmuses
lorises73918593lorises
lotuses74011253lotuses
louses66230283_louses
lupuses936273lupuses
lususes736713lususes
marses84827113mar_ses
merises93421423merises
mimeses1139073mimeses
minutes93513433minutes
mioses84318853mi_oses
mirages102213533mirages
mires75640883mir__es
mirexes1636993mirexes
mises74740563mi__ses
misrules1039383misrules
misses85130873mi_sses
missuses10309683missuses
misuse83213643misuse_
misused104111283misused
misuser93210443misuser
misusers10348073misusers
mitises9315543mitises
mitoses9312183mitoses
momuses1159263momuses
mouses85531423_mouses
mucuses11148513mucuses
muses75134303__muses
neguses837933neguses
nexuses1436743nexuses
nimbuses1244663nimbuses
nonuses73313863nonuses
nouses64627163_nouses
nurses63919353nur_ses
onrushes1135213onrushes
onuses65616253_onuses
opuses84012243_opuses
orrises71312233orrises
overuse10310923overuse_
overused1249443overused
pareses94718873pareses
parises94827183parises
parses85534703par_ses
parures9512693parures
pauses84621473_pauses
perfuses1358663perfuses
perses85428063per_ses
perukes133210113perukes
peruse84016843peruse_
perused103112183perused
peruser93511373peruser
perusers10328803perusers
phrases12711463phrases
pilules9510623pilules
piques1739093piqu_es
pirates93020323pirates
pisses84525083pi_sses
pluses83618073_pluses
poxviruses2262133poxviruses
prases84429023_prases
primuses1237083primuses
prises84133173_prises
prisses94816713prisses
proses84733473_proses
proviruses1554513proviruses
prudes94215443_prudes
prunes83419063_prunes
purses84826373pur_ses
pursues94111373pursues
puses75532203__puses
qurushes2034943qurushes
rases55447213__rases
rebuses94915293rebuses
recuses94619463recuses
refuses104918553refuses
reoviruses1342993reoviruses
rerises73525883rerises
reuses66025523_reuses
rhuses94911793_rhuses
riboses9310443riboses
rictuses1037563rictuses
rinses64720383ri_nses
rises55244043__rises
roses56445773__roses
rouses65436283_rouses
rubes74928413__rubes
rues46044483__ru_es
rules55234253__rules
runes55530223__runes
ruse45938933__ruse_
rushes94724363__rushes
rusks95816193__rusks
rusts55026993__rusts
saroses73619333saroses
scouses93313243scouses
sirees64624583sir_ees
sires55945373sir__es
sirrees73410563sirrees
siruped1036013siruped
sirups83710533siru_ps
sises55233833si__ses
sisses64520603si_sses
soroses73117483soroses
souses64229243_souses
spouses92912813spouses
spruces113810503spruces
sprues84515763spru_es
subviruses1543473subviruses
taluses7311213taluses
thrushes1436523thrushes
thrusts10226523thrusts
tirades8311723tirades
tires55437493tir__es
tissues737463tissues
tonuses73612193tonuses
torses64727953tor_ses
touses64229673_touses
trioses75015653trioses
triunes74311383triunes
truces84916333_truces
trues54925323_tru_es
truss54916923_trus_s
trusses73813633_trusses
trusts64714433_trusts
uprises92012733uprises
uprouses1037553uprouses
uprushes13194863uprushes
urases63723563_urases
uses44931113___uses
uteruses837183uteruses
valguses1234233valguses
valises103516263valises
valses94514613v_alses
values94314943valu_es
vamoses1239143vamoses
varices123313573varices
varies94330873var_ies
varus85921183varu__s
varves124414783var_ves
vases84626263v__ases
veinules1135913veinules
velures1039093velures
venues95115203venu_es
venules104011483venules
verdures12247743verdures
verges104320173ver_ges
verisms123011253verisms
verists103613673verists
verites103822253verites
vermes115019143ver_mes
verse84723583ver_se_
versed104515513ver_sed
verser94516963ver_ser
versers103813513ver_sers
verset94327323ver_set
versets103913093ver_sets
versos93812803ver_sos
verstes104014273verstes
versts93914733ver_sts
versus94211143ver_sus
verves124617883ver_ves
vibes104719953vi__bes
vibists1256483vibists
vibrates132210593vibrates
vibrioses1443923vibrioses
vices105725533vi__ces
vichies15310623vichies
vicunas1285613vicunas
vies75238623vi___es
vinasse1044513vinasse
vinasses1135703vinasses
vines85137643vi__nes
viragoes1245233viragoes
viragos1146713viragos
vireo84816453vir__eo
vireos94212453vir_eos
virgas1048883vir_gas
virgates1237903virgates
virgins1137863virgins
virgule1144283virgule_
virile9313433virile_
virions1039873virions
virls85618603vir__ls
viroids1137923viroids
virtue9358673virtue_
virtuosas1251943virtuosas
virtuose1143183virtuose_
virtuosos1251633virtuosos
virtuous1144663virtuous
virtus94310143vir_tus
virucides1543273virucides
virulent1146433virulent
virusoid1243183virusoid
virusoids1342483virusoids
visages1138693visages
visas84317653vi__sas
viscoses1338343viscoses
vise75632673vi__se_
vised95518763vi__sed
visuals1036853visuals
vitesse1044583vitesse
vitesses1136333vitesses
vitreouses1343003vitreouses
vitrines112610913vitrines
vittles103211113vittles
vivaces1536413vivaces
vogues104011923vogu_es
volumes12298233volumes
volutes102710983volutes
vomituses1483903vomituses
vulguses1243503vulguses
walruses11554973walruses
wamuses1237023wamuses
wires86034913wir__es
wises85633193wi__ses
wisses94619603wi_sses
worses95522953wor_ses
xeroses143612823xeroses

Search took 9 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.1731032896.0
2DLD Change Limit1340274138.47015823.7
3Display Results4134130.1562647.4
 (SQL Overall)1786914138.79920308.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.