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

149 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
cushaws1535629(None) 
cashaws15398571cashaws
cumshaws1842221cumshaws
cushats12288271cushats
cushaw14386981cushaw_
bashaws15347712bashaws
bushwas15105612bushwas
cashaw14439792cashaw_
cashews15428602cashews
chaws135022462c__haws
cumshaw1742302cumshaw_
cushat113513692cusha_t
pshaws14435702_pshaws
shaws116226262__shaws
bashaw14349303bashaw_
bugshas1334513bugsha_s
buqshas2143573buqsha_s
busbars1138153busbars
bushels124110713bushels
bushers124018803bushers
bushes115226113bush_es
bushwa14105143bush_wa
bushwah18123983bushwah
bushwahs19113333bushwahs
cahows14399123c_ahows
casas75327843cas_a_s
casbahs1436463casbahs
cashes114729883cash_es
cashew144311453cashew_
cashoos12310793cashoos
casuals91410523casuals
catspaws1543163catspaws
causals91411183caus_als
caws96036113c___aws
cestas85018543cesta_s
chads116122233c__hads
chais107530313c__hais
chams126028503c__hams
chaos105622863c__haos
chaps125326063c__haps
chars105936643c__hars
chats105730093c__hats
chaw126224633c__haw_
chays135319743c__hays
chews135418513c__hews
chows135618203c__hows
claws106020833c__laws
coshers123618183coshers
coshes115022783cosh_es
costars94218013costars
craws105723123c__raws
crenshaws1741973crenshaws
crushers134010093crushers
crushes124215133crush_es
cuestas957933cuesta_s
cuirass934973cuirass
cuishes122810823cuish_es
cullays12347703cullays
cuppas12458593cuppa_s
curfews15294913curfews
curlews12387393curlews
currans9310613currans
curtals93111623curtals
cuscus1038113cus_cus
cusecs10509153cus_ecs
cushier123610833cushier
cushiest133411043cushiest
cushily15257923cushily
cushion1236403cushion
cushions1335693cushions
cushy134412323cush__y
cusks114916053cus__ks
cuspal1037883cuspa_l
cuspate1138233cuspate
cuspids12427113cuspids
cuspis105010703cus_pis
cusps94913673cus__ps
cuss65430613cus___s
cussers94213403cussers
cusses84522773cus_ses
cussos84210003cus_sos
custard10389973custard
custards11338393custards
customs11348263customs
custos84014313cus_tos
cutlas8313103cutla_s
cutlass938013cutlass
fulhams1543983fulhams
goshawk1862423goshawk
goshawks1962053goshawks
guffaws1762273guffaws
gushers113512513gushers
gushes104719033gush_es
haws106439443___haws
heehaws1643343heehaws
hushaby1842713hushaby
hushes124718593hush_es
hussars10326983hussars
jubhahs2242353jubhahs
kashas133311903kasha_s
kickshaws2052223kickshaws
lushes94022743lush_es
mishaps1438713mishaps
mughals1355763mughals
muscats1138933muscats
mushers124016443mushers
mushes114124563mush_es
nuchals12216933nuchals
outlaws10249603outlaws
pashas115117063pasha_s
pshaw13447513_pshaw_
pushers123814503pushers
pushes114621663push_es
pushups1433653pushups
resaws93713513res_aws
reshows132510453reshows
rickshaws2142613rickshaws
rikshaws1852653rikshaws
rushees103311953rushees
rushers103816103rushers
rushes94724363rush_es
sashays1336333sashays
saws75839483__s_aws
shads95124483__shads
shags95123863__shags
shahs115919513__shahs
shams105829413__shams
shaw108132553__shaw_
shawl116217573__shawl
shawls125411973__shawls
shawm135316153__shawm
shawms14579563__shawms
shawn116417613__shawn
shays116021433__shays
shews115924713__shews
shows115324583__shows
shwas116415103__shwas
slaws85222713__slaws
snaws86116363__snaws
sushis9311183sush_is
thaws116515463__thaws
trishaws1444003trishaws
tushes94319473tush_es
tushies10312163tushies
tussahs10335113tussahs
tussars7359253tussars
unhats91110623_unhats
ushers94415533_ushers
usuals637783_usuals

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.1401276364.3
2DLD Change Limit1340271496.84319586.0
3Display Results1491490.0463239.1
 (SQL Overall)1786911497.02925422.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.