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

103 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
cowbird153443(None) 
cowbind1536611cowbind
cowbirds1644041cowbirds
boobird1235232boobird
catbird1235242catbird
coward12411672cow_ard
cowbinds1634452cowbinds
cowgirl1353272cowgirl
cowherd1636952cowherd
snowbird1443372snowbird
bird76128323___bird
bombard1437333bombard
boobirds1344183boobirds
bowerbird1752083bowerbird
caird85717233c__aird
catbirds1344203catbirds
cebid104314073c_ebi_d
cobber124116843cobber_
cobbers134114753cobbers
cobbier133410163cobbier
cobbled143411633cobbled
cobia94117513co_bi_a
cobias104014993co_bias
cobra95214403co_b_ra
coccid102910743cocci_d
coheir1137583coheir_
coheirs1236753coheirs
coir66327243co__ir_
coirs75221053co__irs
collard103712923collard
collied103316673collied
colubrid1344413colubrid
combed135516543comb_ed
comber125118503comber_
combers134516623combers
combine133014723combine
combined15269183combined
combing143714733combing
concord12510343concord
confirm1437363confirm
conoid9818883conoi_d
copied114618563co_pied
corbie103618203corbi_e
corbies113520123corbies
corbina111911453corbina
cord76740923co___rd
corvid12310473corvi_d
cosied94819883co_sied
cosmid11810643cosmi_d
costard104113353costard
cowards1339613cow_ards
cowbane1437673cowbane
cowbell1445223cowbell
cowberry1843343cowberry
cowboy1637063cowb_oy
cowboyed1943373cowboyed
cowboys1735253cowboys
cowed115637853cow__ed
cower104531773cow_er_
cowered133214653cowered
cowers114625533cow_ers
cowfish1836433cowfish
cowgirls1442493cowgirls
cowhand1665933cowhand
cowherb1735103cowherb
cowherds1735423cowherds
cowhide1636143cowhide
cowhided1843753cowhided
cowier113616163cow_ier
cowing124526323cow_ing
cowled125218393cow_led
cowlick1835263cowlick
cowling134017423cowling
cowpie133511513cowpi_e
cowpies143314283cowpies
cowrie113814283cowri_e
cowries124218013cowries
cowrite123612683cowrite
cowry135512483cow__ry
cowshed1637773cowshed
cozied184112153co_zied
crowbar1444273crowbar_
crowbars1544443crowbars
fatbird1344033fatbird
forbid123312433forbi_d
howdied15296843howdied
jaybird2043123jaybird
lobbied12337173lobbied
lovebird1442643lovebird
lowborn1245143lowborn
lowbred13225363lowbred
maybird1543993maybird
morbid112511463morbi_d
oilbird1043743oilbird
redbird1155263redbird
scombrid1543373scombrid
seabird1055363seabird
snowbirds1542953snowbirds
songbird1243233songbird
sunbird1044743sunbird
toward10311063tow_ard
weird95111283__weird
widowbird1951213widowbird

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.406440125.6
2DLD Change Limit1340271036.11021935.7
3Display Results1031030.0303433.3
 (SQL Overall)1786911036.54627297.7
 
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.