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

336 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
vires8452968(None) 
cires74932911cires
fires85740751fires
hires86134341hires
ires45639281_ires
mires75640881mires
sires55945371sires
tires55437491tires
vibes104719951vibes
vices105725531vices
viers85621951viers
vies75238621vi_es
vines85137641vines
vireo84816451vireo
vireos94212451vireos
virls85618601virls
virus85316841virus
vises84427771vises
wires86034911wires
acres76327762acres
aides65336602aides
aired66032922aired
airer54927892airer
airers64922312airers
airest63825262airest
airns55521032airns
airs46447422air_s
airts55626342airts
apres75426402apres
ares45871022_ares
aures55137092aures
bares75457132bares
bices95029962bices
bides85536772bides
biers76225222biers
bikes117529472bikes
biles75542142biles
bines76946792bines
birds85421332birds
birks114920302birks
birles84920642birles
birls74023162birls
biros75325132biros
birrs74917102birrs
birse74517402birse
birses84717732birses
bises75435622bises
bites75641172bites
bizes165923662bizes
bores76448252bores
bries74942152bries
byres104421382byres
cares77369182cares
ceres75540012ceres
cines75239682cines
cire65836372cire_
cites74435592cites
cores76361852cores
cries75438402cries
cures75645432cures
dares66146702dares
dices86434242dices
dies55653522di_es
dikes105831332dikes
dimes85833042dimes
dines66449152dines
dire56644142dire_
direr64927072direr
direst75024242direst
dirges84915102dirges
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
dites66339152dites
dives95832402dives
dries64733672dries
dures65635922dures
evites94916472evites
eyres84921772eyres
fares85852872fares
feres86038182feres
fibres114312122fibres
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fire76245592fire_
fired94829742fired
firer811229252firer
firers94922682firers
firms105217422firms
firns86018542firns
firs76637712fir_s
fives116027362fives
fixes154723592fixes
fores85847102fores
fries85535602fries
gibes84422522gibes
gies55641422gi_es
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girts65423622girts
gites65630182gites
gives95324872gives
gores65740372gores
gyres94820322gyres
hares86255542hares
heres86245902heres
hides95129422hides
hies74842832hi_es
hikes125426982hikes
hire75538962hire_
hired95226262hired
hiree85427802hiree
hirees95117292hirees
hirer85423122hirer
hirers94518062hirers
hives116925512hives
ices66129642_ices
ides57734232_ides
ire36943172_ire_
ired55131872_ired
iris45732552_iris
irks86220132_irks
ivies84215762ivies
jibes145520322jibes
jives154820812jives
kibes115521112kibes
kiers95320092kiers
kikes85122552kikes
kines95039132kines
kirks84915262kirks
kirns95315452kirns
kirs85831742kir_s
kites95432542kites
lares54852632lares
liers55130402liers
lies46454192li_es
likes96231902likes
limes75636502limes
lines57054572lines
liras56021982liras
lire47845292lire_
litres65220392litres
lives86133192lives
livres94311862livres
lores55045402lores
lures56138532lures
lyres85019962lyres
mares76457632mares
meres75143572meres
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mire66748232mire_
mired85729222mired
mirex146816622mirex
mirks115122142mirks
mirs66940572mir_s
mises74740562mises
mites75141802mites
mitres83922072mitres
mixes147224402mixes
moires8915632moires
mores76249642mores
mures75937222mures
nares55544152nares
nides65229132nides
nines55937342nines
nites55736342nites
nitres65519332nitres
nixes124519622nixes
ogres65818632ogres
ores46056682_ores
ovines94614342ovines
pares77164482pares
peres76246642peres
piers75926332piers
pies66949602pi_es
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pirns76020092pirns
pixes144323172pixes
pores75849032pores
pries74339532pries
pyres105523882pyres
quires154015752quires
rares55247442rares
res35565042__res
ribes75530172ribes
rices75536152rices
rides66140812rides
riles55343642riles
rimes75634542rimes
ripes75435772ripes
rises55244042rises
rites54442552rites
rives85336002rives
seres55448892seres
shires95225572shires
sices75637272sices
sides65838362sides
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sire46150412sire_
sired66134282sired
siree55238812siree
sirees64624582sirees
siren54525822siren
sirens65318152sirens
sirs44338332sir_s
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
sores55454282sores
spires84628112spires
tares57456562tares
tides64830152tides
tiers55526522tiers
ties45248312ti_es
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tire46143352tire_
tired65228902tired
tirls54519802tirls
tiros54524892tiros
titres64718932titres
tores55352672tores
tres46542902_tres
tries55742812tries
tyres84725232tyres
vairs85019132vair_s
vales85434262vales
vanes85130972vanes
varas86028192varas
varies94330872varies
vars75742072var_s
varus85921182varus
varves124414782varves
vases84626262vases
veers84521362veers
vees75439432v_ees
veges94118872veges
venires103012452venires
verbs104614392verbs
verges104320182verges
vermes115019142vermes
verse84723582verse
verses94223762verses
verts85724732verts
verves124617882verves
vexes155719122vexes
vials85822382vials
vibe95124502vibe_
vice95732852vice_
viced115118182viced
vide85432762vide_
video96014952video
videos104911372videos
vids85627542vi_ds
vie65447632vi_e_
vied86328632vi_ed
vier75428152vi_er
view105917672vi_ew
views11489642views
vigas94817882vigas
vigs85427272vi_gs
vile76139802vile_
viler86324162viler
vilest9416842vilest
vills86429322vills
vimen104114752vimen
vims95423312vi_ms
vinas85126342vinas
vine75643682vine_
vined95626152vined
vinos84723072vinos
viols86118102viols
viper105017302viper
vipers114914532vipers
viral86419592viral
virga9310252virga
virgas1048882virgas
virid94116042virid
virl76224472vir_l
viroses10310532viroses
virtu85314092virtu
virtues10338022virtues
virtus94310142virtus
viruses1039412viruses
vis66747612vi__s
visas84317652visas
vise75632672vise_
vised95518762vised
vivas114815022vivas
vive105426622vive_
vivers124717362vivers
vixen153010022vixen
vixens16286202vixens
voces105918052voces
voes75432822v_oes
voices114414012voices
voiles94616442voiles
voles86234042voles
votes84627082votes
wares88250582wares
wides94832822wides
wifes114522562wifes
wiles85437872wiles
wines85546862wines
wipes104827082wipes
wire75839812wire_
wired95327642wired
wirer85124952wirer
wirers94617892wirers
wises85633192wises
wites85536962wites
wives115328922wives
wizes174723342wizes
wries85827742wries
yikes125117752yikes
yipes106017842yipes
yirds96612512yirds
yirrs8469192yirrs
yores85031322yores
zaires1539702zaires
zines145232652zines

Search took 3 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.296603685.8
2DLD Change Limit538003361.58034050.6
3Display Results3363360.0933612.9
 (SQL Overall)1786913361.96990752.2
 
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.