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

155 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
costards11351078(None) 
costard104113351costard_
costars94217991costar_s
custards11338381custards
bastards113310312bastards
bustards11308512bustards
coastwards1643052coastwards
collards113310192collards
costar85518612costar__
costers94128302coster_s
cottars94412232cottar_s
cowards1339612co_wards
custard10389972custard_
custardy14314902custardy
dastards10278082dastards
dotards937252do_tards
mustards11297882mustards
postcards1445732postcards
bastard103012423bastard_
bastardy14326003bastardy
boards94616933bo__ards
boatyards1543963boatyards
bollards11339153bollards
bombards1536493bombards
boyards13399323bo_yards
bustard10389723bustard_
cabstands1453723cabstands
canards10311203c_anards
cards85137933c___ards
cascaras1237693cascaras
casters94729893caster_s
castors94919433castor_s
centares102913893centares
cestas85018543cesta__s
cestoids11308273cestoids
chards125119723c__hards
cisterns10369563cisterns
clochards1743823clochards
coalyards1543523coalyards
coasters104317303coaster_s
coastguards1551443coastguards
coastlands1343313coastlands
coastward1543543coastward_
coaters93525773coater_s
coheads13289233cohea_ds
coleads102911423colea_ds
collard103712923collard_
collars93816573collar_s
colters93522433colter_s
commands15318813commands
compares143816433compares
comparts144210833comparts
concords1358593concords
constants11410913constants
contacts123215213contacts
contains10316533contains
contends112810573contends
contorts101112633contorts
contras93015603cont_ras
cooters94525713cooter_s
copters113621273copter_s
cords86030623co___rds
coshers123618173cosher_s
cosmids1237633cos_mids
cossacks1645223cossacks
costa75523733costa___
costae85319683costa__e
costal85419513costa__l
costally1339723costally
costarred1244703costarred
costate94019273costa_te
costed95623113cost_ed_
coster84331293coster__
costless10310003costless
costmaries1446913costmaries
costmary1545053costmar_y
costrel9310363cost_rel
costrels1038933costrels
costs77231143cost___s
costumes1258013costumes
cotans81317923co_ta_ns
cottages113310493cottages
cottar84613813cottar__
cottas84615573cotta__s
cotters94323433cotter_s
cougars1038423cougar_s
courtyards1651903courtyards
couters93827283couter_s
coutures10311973coutures
coward12411673co_ward_
cowbirds1644043cowbirds
cowhands1765263cowhands
cowherds1735423cowherds
crossarms1343963crossarms
cystoids14306733cystoids
dastard9279703dastard_
discards1238913discards
dotard839053do_tard_
eastwards1344253eastwards
forwards1537043forwards
fosters104220093foster_s
foulards12266463foulards
goliards1045133goliards
hoards104912623ho__ards
holards1148433ho_lards
hostages122311693hostages
hostas94515823hosta__s
instars7411113instar_s
leotards945303leotards
mortars93411523mortar_s
mustard10359533mustard_
mustardy14265053mustardy
octads987333_octa_ds
onwards1137173_onwards
ostmarks1443893_ostmarks
ottars64112223_ottar_s
outadds936193_outadds
outwards1299123_outwards
petards104311153_petards
pochards1646853pochards
pollards11299523pollards
poniards1145823poniards
postages112815323postages
postals93716373posta_ls
postcard1346523postcard_
posterns102713703posterns
posters93927993poster_s
postgrads1344873postgrads
postmarks1744753postmarks
postures10313763postures
potshards1544053potshards
poulards11288233poulards
restarts8310873restarts
retards85015003_retards
ritards8439943_ritards
rosters73727533roster_s
sards64736183__s_ards
shards104319173__shards
stands75118053__stands
stares66038753__stares
stars55836573__star_s
starts65423123__starts
swards105415133__swards
tostada894953tosta_da
tostadas994513tostadas
tostado895943tosta_do
tostados995063tostados
towards1138783to_wards
unitards945623unitards
upstands1144093upstands
upstares10178583upstares
upstarts10165273upstarts
visards11328153vis_ards
westwards1643393westwards
zosters163015403zoster_s

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.1701051123.5
2DLD Change Limit1461621557.61019206.6
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.84322783.5
 
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.