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

308 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
vises8442777(None) 
bises75435621bises
mises74740561mises
rises55244041rises
sises55233831sises
vases84626261vases
vibes104719951vibes
vices105725531vices
vies75238621vi_es
vines85137641vines
vires84529681vires
visas84317651visas
vise75632671vise_
vised95518761vised
wises85633191wises
advises11138972advises
aides65336602aides
aisles64721142aisles
anises64826692anises
apses76823912apses
arises65233802arises
arses55733872arses
asses55629282asses
avisos95410482avisos
axises134413992axises
bases75644352bases
beses75830722beses
biases84618432biases
bices95029962bices
bides85536772bides
bikes117529472bikes
biles75542142biles
bines76946792bines
birses84717732birses
bise66437102bise_
bisks115416802bisks
bites75641172bites
bizes165923662bizes
brises84927612brises
buses75936012buses
cases75048382cases
cines75239682cines
cires74932912cires
cists76624532cists
cites74435592cites
coses76949492coses
crises84529432crises
daises74318982daises
devises114116762devises
dices86434242dices
dies55653522di_es
dieses75218692dieses
dikes105831332dikes
dimes85833042dimes
dines66449152dines
discs85316262discs
dishes104622652dishes
disks105417472disks
dismes95617672dismes
diss56434482dis_s
disses75225962disses
dites66339152dites
dives95832402dives
doses65938502doses
eases56041612eases
egises7312492egises
erses55826802erses
eses45336102_eses
esses56422972esses
evites94916472evites
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fiscs105311882fiscs
fishes125221342fishes
fists85527542fists
fives116027362fives
fixes154723592fixes
frises94124272frises
fuses85628422fuses
gases65633992gases
gibes84422522gibes
gies55641422gi_es
gists66026192gists
gites65630182gites
gives95324872gives
guises74216312guises
hides95129422hides
hies74842832hi_es
hikes125426982hikes
hires86134342hires
hiss75629212his_s
hisses94719352hisses
hists86328372hists
hives116925512hives
hoises94823682hoises
hoses85443182hoses
ibises83610542ibises
ices66129642_ices
ides57734232_ides
ires45639282_ires
irises64221172irises
isles54220562_isles
isms66213472_isms
ivies84215762ivies
jibes145520322jibes
jisms14458002jisms
jives154820812jives
kibes115521112kibes
kikes85122552kikes
kines95039132kines
kiss85227402kis_s
kisses104217332kisses
kists95822112kists
kites95432542kites
krises105016082krises
kvases13467102kvases
lases54944762lases
leses54930812leses
lies46454192li_es
likes96231902likes
limes75636502limes
lines57054572lines
lisles63416282lisles
lisps76913912lisps
lists56628692lists
lives86133192lives
loses56742012loses
lyses84518252lyses
mavises122812992mavises
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mioses84318852mioses
mires75640882mires
mise66043582mise_
miser75430402miser
misers85025702misers
misos76523292misos
miss65339422mis_s
misses85130872misses
mists76633902mists
mites75141802mites
mixes147224402mixes
muses75134302muses
nides65229132nides
nines55937342nines
nisei54214352nisei
niseis63512022niseis
nisus56014392nisus
nites55736342nites
nixes124519622nixes
noises65021852noises
noses55435642noses
oases55330982oases
oses46641512_oses
ovines94614342ovines
pases75346502pases
pavises125315492pavises
peises84125042peises
pies66949602pi_es
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pishes114722102pishes
pisos76021062pisos
piss65033332pis_s
pisses84525082pisses
pistes85325632pistes
pixes144323172pixes
poises84226542poises
poses74642762poses
prises84133172prises
puses75532202puses
raises64826542raises
rases55447212rases
revises104220532revises
ribes75530172ribes
rices75536152rices
rides66140812rides
riles55343642riles
rimes75634542rimes
rinses64720382rinses
ripes75435772ripes
rise45945232rise_
risen54621882risen
riser55431052riser
risers64624782risers
risks94917062risks
risus54216392risus
rites54442552rites
rives85336002rives
roses56445772roses
ruses56136582ruses
seises64026712seises
sices75637272sices
sides65838362sides
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sires55945372sires
sisses64520602sisses
sites56045432sites
sixes124526362sixes
sizes146727762sizes
tides64830152tides
ties45248312ti_es
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
uses44931112_uses
vales85434262vales
valises103516262valises
valses94514612valses
vanes85130972vanes
vase75629652vase_
vasts86423772vasts
vees75439432v_ees
veges94118872veges
verses94223762verses
vests85325982vests
vexes155719122vexes
vials85822382vials
vibe95124502vibe_
vice95732852vice_
viced115118182viced
vide85432762vide_
video96014952video
videos104911372videos
vids85627542vi_ds
vie65447632vi_e_
vied86328632vi_ed
vier75428152vi_er
viers85621952viers
view105917672vi_ew
views11489642views
vigas94817882vigas
vigs85427272vi_gs
vile76139802vile_
viler86324162viler
vilest9416842vilest
vills86429322vills
vimen104114752vimen
vims95423312vi_ms
vinas85126342vinas
vine75643682vine_
vined95626152vined
vinos84723072vinos
viols86118102viols
viper105017302viper
vipers114914532vipers
vireo84816452vireo
vireos94212452vireos
virls85618602virls
viroses10310532viroses
virus85316842virus
viruses1039412viruses
vis66747612vi__s
visa76323872vis_a
visaed104110502visaed
visages1138692visages
viscus11428502viscus
viseed105310982viseed
visit8320962visit
visits9311422visits
visor82512832visor
visors92912222visors
vista85416602vista
vistas94513272vistas
vivas114815022vivas
vive105426622vive_
vivers124717362vivers
vixen153010022vixen
vixens16286202vixens
voces105918052voces
voes75432822v_oes
voices114414012voices
voiles94616442voiles
voles86234042voles
votes84627082votes
wides94832822wides
wifes114522562wifes
wiles85437872wiles
wines85546862wines
wipes104827082wipes
wires86034912wires
wise75737342wise_
wised95123342wised
wiser85522802wiser
wisest95016442wisest
wishes124920952wishes
wisps105214182wisps
wiss75630542wis_s
wisses94619602wisses
wists86728522wists
wites85536962wites
wives115328922wives
wizes174723342wizes
yeses85119322yeses
yikes125117752yikes
yipes106017842yipes
zines145232652zines

Search took 4 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 Limit538003082.82619037.5
3Display Results3083080.0803850.0
 (SQL Overall)1786913083.21955511.3
 
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.