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

191 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
varus8592118(None) 
vagus96713811vagus
varas86028191varas
vars75742071var_s
vatus86114641vatus
vaus75928921va_us
virus85316841virus
acarus8312192acarus
amus65529612_amus
anus47131112_anus
arbs66834732_arbs
arcs67834782_arcs
arcus76918862_arcus
ares45871022_ares
arfs76029962_arfs
argus66716542_argus
arks85936872_arks
arms66137492_arms
ars37670932_ar_s
arts49650262_arts
arum66129032_arum
arums75517832_arums
babus95620332babus
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092bar_s
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carns75937562carns
carps96932252carps
carpus105514302carpus
carrs75730852carrs
cars67364762car_s
carts78946292carts
casus76419252casus
crus65828482_crus
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
earls56127512earls
earns55927562earns
ears46356592ear_s
ecrus75113862ecrus
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
favus114311732favus
garbs86321412garbs
gars55750742gar_s
gaurs66317992gaurs
gurus64318192gurus
gyrus95310802gyrus
habus106317142habus
hakus125114112hakus
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926862harps
harts88441592harts
jarls126120962jarls
jars117338352jar_s
kagus105812032kagus
karns96624142karns
karts97630112karts
kurus98015632kurus
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
larum74317972larum
larums83610532larums
magus85318752magus
manus75924922manus
maras75443282maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261862mar_s
marts77442232marts
nairus639142nairus
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oars46846032oar_s
paras76143042paras
pards85634332pards
pares77164482pares
pareus85420742pareus
paris75145942paris
parks116134462parks
parous84024162parous
parrs75928672parrs
pars67560792par_s
parts77743372parts
praus74621752praus
rakus94413672rakus
ramus76418282ramus
rares55247442rares
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
sorus54527582sorus
tabus74820922tabus
talus55423262talus
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarsus6310512tarsus
tarts57242022tarts
taus46342732ta_us
taxus125512482taxus
torus54329762torus
urus46426132_urus
vacs96226202va_cs
vacua10510462vacua
vague96513112vague
vails85825932vails
vairs85019132vairs
vales85434262vales
valgus1047102valgus
value85719092value
values94314942values
vamps125415482vamps
vanes85130972vanes
vangs96319582vangs
vans76236722va_ns
var66148332var__
vara75530882var_a
varia85824202varia
varias95019902varias
varies94330872varies
various103113102various
varix154313502varix
varna84516172varna
varnas94212822varnas
varuses10310622varuses
varve115716852varve
varves124414782varves
vary105226062var_y
vas67755772va__s
vases84626262vases
vasts86423772vasts
vats76841742va_ts
vatu76524332vatu_
vau66840872va_u_
vavs105720432va_vs
vaws105527322va_ws
venus84918902venus
verbs104614392verbs
versus94211142versus
verts85724732verts
vertus94613602vertus
vires84529682vires
virls85618602virls
virtus94310142virtus
walrus956432walrus
wamus105514682wamus
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
xerus12313332xerus
yards95324612yards
yarns85621792yarns
zarfs174713622zarfs

Search took 5 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.266671770.7
2DLD Change Limit538001914.17012901.7
3Display Results1911910.1101736.4
 (SQL Overall)1786911914.54639307.3
 
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.