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 “cowhand” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
cowhand166593(None) 
cowhands1765261cowhands
command14399212command
coward12411672cow_ard
cowbane1437672cowbane
cowbind1536612cowbind
cowhage1636292cowhage
cowherd1636952cowherd
cowman13910372cowman_
lowland1134692lowland
blowhard1743733blowhard
bowhead1636433bowhead
bowman13129853bowman_
browband1643883browband
chad105525503c__ha_d
chang115418563c__hang
chant105932693c__hant
chard116124743c__hard
chowhound2152313chowhound
clochard1644293clochard
clubhand1642433clubhand
cochair1446313cochair
cochin131313203cochin_
cochins141413093cochins
cofound1335513cofound
cohead123811123co_head
cohune1189423co_hune
colead94114643colea_d
collard103712923collard
commando15275753commando
commands15318813commands
commend144010183commend
company1619711143company
compend144010303compend
congaed11399743congaed
contend103511893contend
coolant9316463coolant
corban10314693corban_
corbans11313173corbans
coshed124217543cosh_ed
coshing134316433coshing
costard104113353costard
cotan71521783co_tan_
cotans81317923co_tans
couchant1549053couchant
courant9317973courant
cowage12310663cow_age
cowards1339613cow_ards
cowbanes1537423cowbanes
cowbinds1634453cowbinds
cowbird1534433cowbird
cowed115637843cow__ed
cowered133214643cowered
cowhages1736103cowhages
cowherb1735103cowherb
cowherds1735423cowherds
cowhide1636133cowhide
cowhided1843743cowhided
cowing124526323cow_ing
cowled125218383cow_led
cowling134017413cowling
cowmen13810923cowmen_
cowpat13312033cowpa_t
cowpats1437713cowpats
cowshed1637773cowshed
cropland1346303cropland
dockhand1953393dockhand
downland1364533downland
forehand1537693forehand
gormand1157453gormand
gowan95415743gow_an_
gowaned1235763gow_aned
gowans105512293gow_ans
gowany13457493gow_any
hand86833703___hand
holland11349473holland
lochan1139093lochan_
lochans1248833lochans
longhand1344493longhand
lowlands1244373lowlands
norland837163norland
offhand1742883offhand
plowland1442743plowland
pochard1537363pochard
roband92310723ro_band
rowan85418733row_an_
rowans95715343row_ans
snowland1243833snowland
soland75115043so_land
sowans94215893sow_ans
toward10311063tow_ard
towhead1435223towhead
towmond1394203towmond
unhand10410383_unhand
wand85833873__w_and
whang124813383__whang

Search took 7 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.1561145455.1
2DLD Change Limit134027966.68620045.9
3Display Results96960.0332909.1
 (SQL Overall)178691966.87525991.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.