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

359 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
advises1113897(None) 
advices13136931advices
advise10139221advise_
advised12136041advised
advisee11147151advisee
advisees12154131advisees
adviser11135781adviser
advisers12135001advisers
admires1038662admires
admixes1765962admixes
adonises92611432adonises
advice12107882advice_
advisor11134162advisor
advisors12143902advisors
aegises8311372aegises
anises64826692a_nises
arises65233802a_rises
arrises71617582arrises
aspises9611642aspises
avisos95410482a_visos
axises134413992a_xises
caddises12329352caddises
daises74318982_daises
davies105020512davi_es
devises114116762devises
mavises122812992mavises
parvises133911912parvises
pavises125315492pavises
revises104220532revises
vises84427772__vises
abases85720773a_bases
abatises10311013abatises
abides94719893a_bides
abioses9311493abioses
abscises1246233abscises
abuses85119103a_buses
abysses1234863abysses
accuses114112193accuses
actives12311523actives
adages8412953ad_ages
addaxes1634573addaxes
addicts1176013addicts
addles84216603ad_dles
address956103address
adduces1185763adduces
adenines9310193adenines
adenoses947903adenoses
adheres11310163adheres
adieu6417423ad_i_eu
adieus739633ad_ieus
adios65822863ad_i_os
adiposes1137173adiposes
adits66523713ad_i_ts
adjures1536233adjures
adjusts1544513adjusts
admass957143admas_s
admasses1135413admasses
admire949933admire_
admired1135703admired
admirer1035523admirer
admirers1134713admirers
admits9411413admi_ts
admixed1833733admixed
adobes94411533ad_obes
adores74420723ad_ores
advances1445613advances
advects13276013advects
advents11309473advents
adverbs13254273adverbs
adverse1145953adverse_
advertises1445913advertises
adverts11308513adverts
advisedly1741953advisedly
advising1336153advising
advisories1442993advisories
advisory15132943advisory
adzes155913803ad__zes
aediles83413903aediles
aeries64737783aeri_es
affines1339483affines
affixes2035503affixes
ageisms1056603ageisms
ageists848493ageists
aggies83515513aggi_es
agisms9399393a_gisms
agists75713173a_gists
agnizes17328843agnizes
agonises92613163agonises
aides65336603a__ides
aisles64721143a__isles
albites9313203albites
aldoses8311203aldoses
aliases7914493aliases
alines65735223a_lines
alkies104518093alki_es
alkines114415733alkines
allies63827673alli_es
alpines94016193alpines
alsikes1137263alsikes
alvine94614583alvine_
amasses93912853amasses
amices105018013a_mices
amides95722663a_mides
amies76837693a_mi_es
amines84727983a_mines
amiss75823073a_mis_s
ammines11312673ammines
amuses85117943a_muses
animes84719593a_nimes
anise55129703a_nise_
ankuses1148203ankuses
anlases72514903anlases
antisex1439693antisex
anuses66218773a_nuses
anviled1138953anviled
anvils9219713anvi_ls
aorists74215833aorists
apheses12610703apheses
aphides134711203aphides
apices104916263a_pices
aplites9314933aplites
apposes11511473apposes
apprises12310963apprises
apses76823913a__pses
apsides103911303apsides
arcuses94814693arcuses
arguses84711743arguses
arise56436433a_rise_
arisen65316793a_risen
arkoses113910833arkoses
armies85123693armi_es
arouses74921293arouses
arrases71214543arrases
arrives101311513arrives
arses55733873a__rses
arsines73518813arsines
artistes83213343artistes
artists74215593artists
asceses938623asceses
ascites9312603ascites
asepses946363asepses
asides75118873a_sides
askeses1136463askeses
aspires9612043aspires
asses55629283a__sses
assists738473assists
assizes1638453assizes
atavisms1346993atavisms
atavists1137583atavists
atlases72410643atlases
atomises103514403atomises
attires72312953attires
audiles83112613audiles
augites8312183augites
aurists74615783aurists
autisms94311553autisms
autists73814853autists
auxeses1435623auxeses
avenses1049643avenses
aves76142603a_v__es
avgases11106313avgases
avians93711563a_vians
aviates10313063a_viates
avions94114393a_vions
aviso85713963a_vis_o
avoset9315673a_voset
avosets1036663a_vosets
avulses1035433avulses
axised14438963a_xised
axites134913833a_xites
azides165113803a_zides
azines155517073a_zines
azotises1737603azotises
badasses1136173badasses
baddies114017873baddi_es
baptises1238923baptises
betises94816123betises
bevies114017303bevi_es
bises75435623__bises
bovines12412663bovines
braises93818873braises
brises84927613_brises
bruises93212913bruises
caddices14297853caddices
caddies113718383caddi_es
caddised13315893caddised
camises114218463camises
canvases13349523canvases
cassises103811743cassises
cavies114525003cavi_es
cerises94722253cerises
chaises124317493chaises
civies114116443civi_es
civisms1436073civisms
clevises1336903clevises
crises84529433_crises
cruises93514443cruises
cutises94414913cutises
dacites101114593dacites
dadaisms1245123dadaisms
dadaists1045583dadaists
daddies103414943daddi_es
daisies84217093_daisies
danishes121710493danishes
dassies84418663dassies
datives11310073datives
davits104012363davi_ts
deices94119373_deices
deisms94411043_deisms
deists74916433_deists
demises103719563demises
devices133212583devices
devise104215753devise_
devised123712563devised
devisee113812713devisee
devisees12358283devisees
deviser114212393deviser
devisers12339863devisers
dices86434243_d_ices
dies55653523_d_i_es
dieses75218693_dieses
dikes105831333_d_ikes
dimes85833043_d_imes
dines66449153_d_ines
discs85316263_d_iscs
dishes104622653_d_ishes
disks105417473_d_isks
dismes95617673_d_ismes
diss56434483_d_is_s
disses75225963_disses
dites66339153_d_ites
dives95832403_d_ives
divides123211453divides
divines113514723divines
doses65938503_d_oses
dosses76126273_dosses
douses74928933_douses
dowses105718303_dowses
dries64733673_dri_es
drives105117113_drives
druses75517253_druses
dulses73913653_dulses
dwines105013103_dwines
eddies83313163eddi_es
ediles74016983ed_iles
egises7312493_egises
envies9314053envi_es
evites94916473_evites
excises1638933excises
faddisms15264983faddisms
faddists13235543faddists
fauvisms1643743fauvisms
fauvists1443843fauvists
favisms1535443favisms
favuses1336183favuses
finises10312903finises
fraises104215693fraises
frises94124273_frises
guises74216313_guises
haggises1335883haggises
hoises94823683_hoises
ibises83610543_ibises
idolises938763idolises
incises93414893incises
invites103915813invites
iodises83413633iodises
ionises72916433ionises
irises64221173_irises
ivies84215763_ivi_es
jadeites1645823jadeites
kaddishes1844093kaddishes
krises105016083_krises
kvases13467103_kvases
laddies93715053laddi_es
ladies75124883lad_i_es
laicises1039573laicises
lapises93513463lapises
lavishes1457403lavishes
levies93919863levi_es
lewises1039133lewises
liaises7311053liaises
lorises73918593lorises
madrases112610003madrases
malaises10312333malaises
mantises10317923mantises
mavies114923193mavi_es
merises93421423merises
misadvises1642893misadvises
mises74740563__mises
mitises9315543mitises
movies115118453movi_es
navies95218623navi_es
navvies1335323navvi_es
noises65021853_noises
novices1238223novices
odists749853od_ists
orrises71312233orrises
ovines94614343_ovines
paddies113715723paddi_es
parises94827183parises
parvise124211693parvise_
pastises103616053pastises
pavise114714803pavise_
paviser12489093paviser
pavisers13387443pavisers
pavisse12546813pavisse
pavisses13397103pavisses
peises84125043_peises
pelvises1337273pelvises
penises9318193penises
poises84226543_poises
praises94121103praises
previses133814283previses
prises84133173_prises
rachises131412413rachises
radices102314263rad_ices
radishes1269463rad_ishes
radiuses937043radiuses
radixes15259343rad_ixes
raises64826543_raises
ravines104220233ravines
ravishes1478043ravishes
remises93423483remises
rerises73525883rerises
reviles104421353reviles
revise94019743revise_
revised113815483revised
reviser104114663reviser
revisers113511933revisers
revives134715543revives
rises55244043__rises
sadisms10359113sad_isms
sadists83310853sad_ists
savines104417633savines
savvies1337603savvi_es
seises64026713_seises
semises93916553semises
sises55233833__sises
speises93813933speises
tabbises12236523tabbises
tallises82713263tallises
tamises92715973tamises
tapises92914013tapises
unadvised1443283unadvised
uprises92012733uprises
valises103516263valises
vases84626263__vases
vibes104719953__vibes
vices105725533__vices
vies75238623__vi_es
vines85137643__vines
vires84529683__vires
visas84317653__visas
vise75632673__vise_
vised95518763__vised
waddies124214753waddi_es
wadies105121203wad_i_es
wavies125019843wavi_es
wises85633193__wises

Search took 8 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.406440125.6
2DLD Change Limit1340273596.83019623.3
3Display Results3593590.1402564.3
 (SQL Overall)1786913597.37624226.0
 
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.