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 “virus” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
virus8531684(None) 
varus85921181varus
vires84529681vires
virls85618601virls
virtus94310141virtus
airbus848342airbus
airns55521032airns
airs46447422air_s
airts55626342airts
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
chirus114615692chirus
circus104310592circus
cires74932912cires
cirrus8349172cirrus
citrus83610922citrus
crus65828482_crus
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
ecrus75113862ecrus
ficus105015492ficus
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girts65423622girts
gurus64318192gurus
gyrus95310802gyrus
hilus84817642hilus
hires86134342hires
ires45639282_ires
iris45732552_iris
irks86220132_irks
kirks84915262kirks
kirns95315452kirns
kirs85831742kir_s
kurus98015632kurus
lieus56218482lieus
liras56021982liras
minus75223932minus
mires75640882mires
mirks115122142mirks
mirs66940572mir_s
nairus639142nairus
nidus65913572nidus
nisus56014392nisus
pilus75921062pilus
pious74621272pious
pirns76020092pirns
risus54216392risus
sinus55523852sinus
sires55945372sires
sirs44338332sir_s
sirup74014912sirup
sirups83710532sirups
situs55019232situs
sorus54527582sorus
tires55437492tires
tirls54519802tirls
tiros54524892tiros
torus54329762torus
urus46426142_urus
vagus96713812vagus
vairs85019132vair_s
varas86028192varas
vars75742072var_s
vatus86114642vatus
vaus75928922v_aus
venus84918902venus
verbs104614392verbs
versus94211142versus
verts85724732verts
vertus94613602vertus
vials85822382vials
vibes104719952vibes
vices105725532vices
vids85627542vi_ds
viers85621952viers
vies75238622vi_es
views11489642views
vigas94817882vigas
vigs85427272vi_gs
vills86429322vills
villus93611222villus
vims95423312vi_ms
vinas85126342vinas
vines85137642vines
vinos84723072vinos
vinous93914172vinous
viols86118102viols
viral86419592viral
vireo84816452vireo
vireos94212452vireos
virga9310252virga
virgas1048882virgas
virid94116042virid
virl76224472vir_l
virtu85314092virtu
virtue9358672virtue
virtues10338022virtues
viruses1039412viruses
vis66747612vi__s
visas84317652visas
viscus11428502viscus
vises84427772vises
vivas114815022vivas
wires86034912wires
xerus12313332xerus
yirds96612512yirds
yirrs8469192yirrs

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001181.56034487.2
3Display Results1181180.0333575.8
 (SQL Overall)1786911181.90693751.8
 
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.