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

197 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
advised1213604(None) 
advise10139221advise_
advisee11147151advisee
adviser11135781adviser
advises11138971advises
admired1135702admired
admixed1833732admixed
advice12107882advice_
advices13136932advices
advisedly1741952advisedly
advisees12154132advisees
advisers12135002advisers
advisor11134162advisor
anviled1138952anviled
axised14438962a_xised
caddised13315892caddised
devised123712562devised
revised113815482revised
unadvised1443282unadvised
vised95518762__vised
abased96514993a_based
abided105313313a_bided
abscised1364133abscised
abused95614273a_bused
accused12368423accused
adapted1135843adapted
added84918433ad__ded
addicted1345073addicted
addled94112523ad_dled
adduced1274353adduced
adeemed1145393adeemed
adhered1239233adhered
adieu6417423ad_i_eu
adjoined1743513adjoined
adjured1634883adjured
adjusted1743613adjusted
admire949933admire_
admirer1035523admirer
admires1038663admires
admitted1234763admitted
admixes1765963admixes
adonises92611433adonises
adopted1136253adopted
adored84714243ad_ored
adorned9256893adorned
advanced1543313advanced
advected1534533advected
adverse1145953adverse_
adverted1336103adverted
advertised1544093advertised
advising1336153advising
advisors12143903advisors
advisory15132943advisory
adzed166012543ad__zed
aegises8311373aegises
aeried74221863aeri_ed
affined1436413affined
affixed2134123affixed
agisted938203a_gisted
agnized18247223agnized
agonised10248483agonised
aided75828933a__ided
ailed66240283a__iled
aimed85626053a__imed
aired66032923a__ired
aisled74516183a__isled
alined75221403a_lined
aliped95414283a_liped
allied74217153alli_ed
alvine94614583alvine_
amassed10388633amassed
amused94412513a_mused
anise55129703a_nise_
aniseed839403a_niseed
anises64826693a_nises
antired82316193antired
antisex1439693antisex
anvilled1236483anvilled
apposed1247853apposed
apprised1337713apprised
ariled75620323a_riled
arise56436433a_rise_
arisen65316793a_risen
arises65233803a_rises
aroused84914343aroused
arrased8149863arrased
arrises71617583arrises
arrived11127353arrived
aspired1068173aspired
aspises9611643aspises
assisted936233assisted
atomised11278833atomised
attired8238913attired
audited939033audited
availed1135973availed
aviated11310263a_viated
avid88325963a_vi__d
aviso85713963a_vis_o
avisos95410483a_visos
avoided1235553avoided
avoset9315673a_voset
avowed1335963a_vowed
avulsed1133833avulsed
awaited1146963awaited
axises134413993a_xises
azotised1844443azotised
badassed1244273badassed
baptised1335263baptised
braised104014803braised
bruised10389503bruised
caddied123710563caddi_ed
caddises12329353caddises
canvased14246223canvased
caviled1348723caviled
cruised103710213cruised
daises74318983_daises
daisied93410013_daisied
davened124610073davened
davies105020513davi_es
deiced104214483_deiced
demised113613683demised
deviled124112183deviled
devise104215753devise_
devisee113812713devisee
deviser114212393deviser
devises114116763devises
diced95824683_d_iced
died66137853_d_i_ed
diked115024683_d_iked
dined76431993_d_ined
disced104914653_d_isced
dished114318713_d_ished
disked125015763_d_isked
dissed85220183_dissed
dived106321373_d_ived
divided13378593divided
divined12329693divined
doiled84817293_doiled
doited85016633_doited
dosed76626913_d_osed
dossed84516633_dossed
doused84821163_doused
dowsed115015013_dowsed
dried75321383_dri_ed
dwined114610213_dwined
eddied9248323eddi_ed
edited83913673ed_ited
envied1038833envi_ed
evited104013143_evited
excised1736673excised
guised84612173_guised
hoised105117433_hoised
idolised1045673idolised
incised102911583incised
invited113612463invited
iodised9329243iodised
ionised82911493ionised
irised73913153_irised
ivied94710523_ivi_ed
laicised1145643laicised
lavished1555133lavished
levied104111433levi_ed
liaised837113liaised
mavises122812993mavises
misadvised1742633misadvised
noised75416233_noised
parvise124211693parvise_
parvises133911913parvises
pavise114714803pavise_
paviser12489093paviser
pavises125315493pavises
peised94817683_peised
poised94918473_poised
praised104214813praised
prevised143611073prevised
prised94322203_prised
radioed939673rad_ioed
raised76120333_raised
ravined115411823ravined
ravished1555713ravished
remised103516843remised
reviled114417923reviled
revise94019743revise_
reviser104114663reviser
revises104220533revises
revived144211653revived
savvied1433803savvi_ed
seised74218123_seised
viced115118183__viced
vied86328633__vi_ed
vined95626153__vined
visaed104110503__visaed
vise75632673__vise_
viseed105310983__viseed
vises84427773__vises
waddied13358563waddi_ed
wised95123343__wised

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.423422437.4
2DLD Change Limit1340271977.28018410.3
3Display Results1971970.0633127.0
 (SQL Overall)1786911977.76623009.4
 
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.