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

194 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
lavishes145740(None) 
lavashes1445571lavashes
lavished1555131lavished
lavisher1445081lavisher
lavishers1564641lavishers
lavishest1554881lavishest
ravishes1478041ravishes
banishes131812462banishes
danishes121710492danishes
famishes1658282famishes
lapises93513462lapis_es
lashes94831002la__shes
lavish124112982lavish__
lavishly1744412lavishly
lavishness1644712lavishness
marishes13512552marishes
mavises122812992mavis_es
parishes13314752parishes
pavises125315492pavis_es
pavisses13397102pavisses
planishes14138522planishes
radishes1269462radishes
ravished1555712ravished
ravisher1465462ravisher
ravishers1564782ravishers
vanishes141610752vanishes
abashes12510373_abashes
advisees12154133advisees
advises11138973advis_es
aisles64721143_a_isles
anises64826693_anis_es
arises65233803_aris_es
ashes86230613_a__shes
aviates10313063_aviates
avisos95410483_avis_os
axises134413993_axis_es
babiches1735253babiches
banished14189063banished
banisher13169183banisher
banishers14258053banishers
bashes115631393ba__shes
batfishes1746583batfishes
batistes1039713batistes
blandishes1644613blandishes
blemishes1665083blemishes
calashes13310533calashes
caliches153812263caliches
camises114218463camis_es
cashes114729883ca__shes
catfishes1746303catfishes
cavefishes2143863cavefishes
caviares1337993caviares
cavies114525003cavi__es
cavities131412613cavities
ceviches1834843ceviches
clashes124017283cla__shes
clavicles1643673clavicles
clevises1336903clevis_es
cuishes122810823_cuishes
daises74318983da_is_es
daisies84217093da_isies
dashes106124983da__shes
davies105020513davi__es
dervishes1644933dervishes
devisees12358283devisees
devises114116763devis_es
dishes104622653__dishes
enravishes1642153enravishes
evanishes1545603evanishes
famished1766023famished
fashes124524023fa__shes
favisms1535443favis_ms
favuses1336183favus_es
fetishes1437153fetishes
finishes1438983finishes
fishes125221343__fishes
flashes133916103fla__shes
flatfishes1943993flatfishes
flavines1437893flavi_nes
flemishes1765243flemishes
galoshes1236893galoshes
gamashes1456943gamashes
garfishes16167083garfishes
garnishes13198813garnishes
gashes105725153ga__shes
glacises1138503glacis_es
hagfishes1945153hagfishes
hashes125024803ha__shes
hashishes1444393hashishes
kaddishes1844093kaddishes
kavasses1544303kavasses
knishes1438263_knishes
labiates101011513labiates
laches116528343la__ches
ladies75124883ladi__es
ladyfishes2052843ladyfishes
laichs115110893la_ich_s
laicises1039573laicis_es
laighs10508803la_igh_s
laities7320343la_ities
laliques1744833laliques
lamister1037653lamister
lamisters1157123lamisters
languishes1444243languishes
lapides103012043lapi_des
lapses85217693la_ps_es
larches124416443la_rches
lases54944763la__s_es
lashed105625213la__shed
lasher94824533la__sher
lashers104121833la__shers
lasses64827593la__sses
lassies74420103la_ssies
lassoes74613853la_ssoes
latches123320123la_tches
lathes95127493la__thes
latices9313763lati_ces
latigoes9306163latigoes
latish92416173latish__
launches1387903launches
lavaboes1344433lavaboes
lavages1138603lav_ages
lavash12597373lavash__
laves86039153lav___es
lavishing1644553lavishing
lawines103313563lawi_nes
laxities1539093laxities
lazies154418783lazi__es
leashes103514403l_eashes
levies93919863levi__es
levities11310713levities
lewises1039133lewis_es
liaises7311053liais_es
liches114724293l__iches
lisles63416283l__isles
lorises73918593loris_es
lushes94022743l__ushes
marshes123615373ma_rshes
mashes115030003ma__shes
mavies114923193mavi__es
minishes13310583minishes
monishes13311483monishes
navies95218623navi__es
oarfishes15156953oarfishes
panfishes1737593panfishes
parises94827183paris_es
parvises133911913parvis_es
pashes115828393pa__shes
pavise114714803pavis_e_
paviser12489093pavis_er
pavisers13387443pavisers
pavisse12546813pavisse_
perishes13313753perishes
pishes114722103__pishes
planished1566123planished
planisher1495853planisher
planishers1584773planishers
plashes124417393pla__shes
plenishes1487083plenishes
polishes13711783polishes
punishes1338113punishes
raises64826543ra_is_es
rashes95330153ra__shes
ratfishes1546103ratfishes
ravines104220233ravi_nes
ravish123414033ravish__
relishes11311953relishes
revises104220533revis_es
sashes94728483sa__shes
savines104417633savi_nes
sawfishes1845743sawfishes
seviches1635803seviches
slashes103619103sla__shes
slavish1338233slavish__
slavishly1843243slavishly
slavishness1753703slavishness
squishes20198393squishes
swishes133411373_swishes
tamises92715973tamis_es
tapises92914013tapis_es
tarnishes12188893tarnishes
unwishes14147483unwishes
valises103516263valis_es
vanished15207743vanished
vanisher14167453vanisher
vanishers15186613vanishers
varnishes15207913varnishes
vises84427773__vis_es
wampishes1944303wampishes
washes124425493wa__shes
wavicles1633783wavicles
wavies125019843wavi__es
whishes16309443_whishes
wishes124920953__wishes

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621948.18617855.1
3Display Results1941940.1601212.5
 (SQL Overall)1786911948.50221017.5
 
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.