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

223 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
ravishes147804(None) 
lavishes1457401lavishes
radishes1269461radishes
ravished1555711ravished
ravisher1465461ravisher
ravishers1564781ravishers
banishes131812472banishes
danishes121710502danishes
enravishes1642152enravishes
famishes1658282famishes
lavashes1445572lavashes
lavished1555132lavished
lavisher1445082lavisher
lavishers1564642lavishers
lavishest1554882lavishest
marishes13512552marishes
mavises122812992mavis_es
parishes13314762parishes
pavises125315492pavis_es
pavisses13397102pavisses
raises64826542ra_is_es
rashes95330152ra__shes
ratfishes1546102ratfishes
ravines104220232ravi_nes
ravish123414042ravish__
relishes11311952relishes
revises104220542revis_es
vanishes141610772vanishes
abashes12510373_abashes
advisees12154133advisees
advises11138973advis_es
aisles64721143_a_isles
anises64826703_anis_es
arises65233803_aris_es
arrises71617583arris_es
artistes83213363artistes
ashes86230613_a__shes
aviates10313083_aviates
avisos95410493_avis_os
axises134413993_axis_es
babiches1735253babiches
banished14189073banished
banisher13169193banisher
banishers14258053banishers
bashes115631393ba__shes
batfishes1746583batfishes
batistes1039713batistes
braises93818873bra_is_es
brandishes1645893brandishes
brashes124518463bra__shes
calashes13310543calashes
caliches153812273caliches
camises114218463camis_es
cashes114729883ca__shes
catfishes1746303catfishes
cavefishes2143863cavefishes
caviares1337993caviares
cavies114525003cavi__es
cavities131412613cavities
ceviches1834843ceviches
crashes124618403cra__shes
crawfishes2143593crawfishes
crayfishes2143403crayfishes
cuishes122810823_cuishes
daises74318983da_is_es
daisies84217093da_isies
dashes106124983da__shes
davies105020513davi__es
dervishes1644933dervishes
devisees12358283devisees
devises114116763devis_es
dishes104622653__dishes
enravished1742193enravished
evanishes1545613evanishes
famished1766023famished
fashes124524023fa__shes
favisms1535443favis_ms
favuses1336183favus_es
fetishes1437153fetishes
finishes1438983finishes
fishes125221343__fishes
fraises104215693fra_is_es
galoshes1236913galoshes
gamashes1456953gamashes
garfishes16167083garfishes
garnishes13198813garnishes
gashes105725153ga__shes
gravies11314093gravi__es
gravities1338303gravities
grayfishes2043633grayfishes
hagfishes1945153hagfishes
hashes125024803ha__shes
hashishes1444393hashishes
kaddishes1844093kaddishes
kavasses1544303kavasses
knishes1438263_knishes
lapises93513463lapis_es
lashes94831003la__shes
lavish124112993lavish__
lavishly1744413lavishly
lavishness1644713lavishness
marshes123615373ma_rshes
mashes115030003ma__shes
mavies114923193mavi__es
minishes13310583minishes
monishes13311483monishes
navies95218623navi__es
oarfishes15156953oarfishes
panfishes1737593panfishes
parises94827193paris_es
parvises133911923parvis_es
pashes115828393pa__shes
pavise114714803pavis_e_
paviser12489093pavis_er
pavisers13387443pavisers
pavisse12546813pavisse_
perishes13313753perishes
pishes114722103__pishes
planishes14138533planishes
polishes13711783polishes
praises94121113pra_is_es
praxises1739063praxis_es
previses133814293previs_es
provisoes1446653provisoes
punishes1338113punishes
rabies85226023rabi__es
rachises131412413rachis_es
racisms112310813racis_ms
racists92613323racis_ts
radiates92415303radiates
radices102314263radi_ces
radicles11249703radicles
radish103516923radish__
radiuses937043radiuses
radixes15259343radi_xes
raise54828053ra_is_e_
raised76120333ra_is_ed
raiser66620103ra_is_er
raisers73617393ra_isers
raisins72715343ra_isins
rakish134313973rakish__
rakishly1844293rakishly
rakishness1744613rakishness
ramies84630463rami__es
ramifies13310503ramifies
ramilies10311833ramilies
ranches123620113ra_nches
raphes115117453ra__phes
rapines95120863rapi_nes
rapists92510753rapis_ts
rarifies11311943rarifies
rarities8316333rarities
rases55447213ra__s_es
rasher95024123ra__sher
rashers104020913ra__shers
rashest103916873ra__shest
rassles73513923ra_ssles
ratches123620463ra_tches
ratifies11313513ratifies
ratines75328583rati_nes
ratites74920683rati_tes
raunches1368053raunches
ravages1139403rav_ages
raves85441973rav___es
ravigotes1343513ravigotes
ravine95522223ravi_ne_
ravined115411823ravi_ned
ravings114614503ravi_ngs
ravins94622563ravi__ns
raviolis1146103raviolis
ravishing1634983ravishing
ravishment1855123ravishment
ravishments1954113ravishments
rawish123012923rawish__
realises82420183realis_es
redfishes1645793redfishes
rehashes1436953rehashes
relished1239433relished
remises93423483remis_es
rerises73525883reris_es
reshes94124363r__eshes
reviles104421363revi_les
revisals1136823revisals
revise94019753revis_e_
revised113815493revis_ed
reviser104114673revis_er
revisers113511943revisers
revisits1137433revisits
revisors11379073revisors
revives134715553revi_ves
rewashes1447033rewashes
riches115022083r__iches
rikishas1542543rikishas
rises55244043r__is_es
rishis9312453r__ishis
rivieres1136013rivieres
rubbishes1644303rubbishes
rushes94724363r__ushes
sashes94728483sa__shes
savines104417633savi_nes
sawfishes1845743sawfishes
seviches1635803seviches
squishes20198393squishes
swishes133411373_swishes
tamises92715973tamis_es
tapises92914013tapis_es
tarnishes12188893tarnishes
trashes104119263tra__shes
travoises1245863travois_es
unravished1742773unravished
unwishes14147483unwishes
valises103516273valis_es
vanished15207763vanished
vanisher14167473vanisher
vanishers15186623vanishers
varnishes15207923varnishes
vises84427773__vis_es
wampishes1944303wampishes
washes124425493wa__shes
wavicles1633783wavicles
wavies125019843wavi__es
whishes16309443_whishes
wishes124920953__wishes

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622237.29620033.2
3Display Results2232230.0932397.8
 (SQL Overall)1786912237.81222873.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.