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

222 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
costard10411335(None) 
costar85518611costar_
costards113510791costards
costars94218011costars
custard10389971custard
bastard103012422bastard
bustard10389722bustard
coastward1543552coastward
collard103712922collard
costa75523732costa__
costae85319682costa_e
costal85419512costa_l
costarred1244702costarred
costate94019272costate
costed95623112cost_ed
coster84331292coster_
costers94128332costers
costmary1545052costmary
cottar84613812cottar_
cottars94412242cottars
coward12411672co_ward
custards11338392custards
custardy14314902custardy
dastard9279702dastard
dotard839052do_tard
mustard10359532mustard
postcard1346522postcard
bastards113310313bastards
bastardy14326003bastardy
board85523003bo__ard
boatyard1444073boatyard
bollard103210503bollard
bombard1437333bombard
boyard125411283bo_yard
bustards11308513bustards
cabstand1344413cabstand
canard9314763c_anard
card710245873c___ard
cascara1138313cascara
caster85232573caster_
casters94729903casters
castled104311513castled
castor84418533castor_
castors94919443castors
centare93113703centare
cesta75419483cesta__
cestas85018543cesta_s
cestoid104011673cestoid
chard116124743c__hard
cisted95217523cist_ed
cistern93310703cistern
clochard1644293clochard
coalyard1444093coalyard
coastal9411043coasta_l
coasted104015953coast_ed
coaster94219043coaster_
coasters104317333coasters
coastguard1451573coastguard
coastland1243683coastland
coastwards1643063coastwards
coated94927043coat_ed
coater84329573coater_
coaters93525793coaters
cohead123811123cohea_d
coital84117053coita_l
colead94114643colea_d
collar83816173collar_
collards113310193collards
collared113211143collared
collars93816573collars
colter84625093colter_
colters93522443colters
cometary1547693cometary
command14399213command
compare135814993compare
compared153811823compared
compart134016003compart
concord12510343concord
congaed11399743congaed
constant10515593constant
contact1144020683contact
contain9315833contain
contend103511893contend
contort91422343contort
contra83314703cont_ra
contrary1347493contrary
contras93015623contras
cooter85128613cooter_
cooters94525723cooters
copter109822013copter_
copters113621283copters
cord76740923co___rd
coshed124217543cos_hed
cosher114819903cosher_
coshered14610293coshered
coshers123618183coshers
cosied94819883cos_ied
cosier84423753cosier_
cosmid11810643cos_mid
cossack1545823cossack
cost68057943cost___
costally1339733costally
costing104323023costing
costive12312843costive
costly114012333cost_ly
costrel9310373costrel
costs77231143cost__s
costume1157853costume
costumed1365033costumed
cotan71521783co_ta_n
cotans81317923co_tans
coted85033853co_t_ed
cotta75818573cotta__
cottae84615703cotta_e
cottage104210573cottage
cottas84615573cotta_s
cotter84926673cotter_
cottered112511733cottered
cotters94323443cotters
cougar958783cougar_
cougars1038443cougars
courtyard1542193courtyard
couter84930223couter_
couters93827303couters
couture9310623couture
covary1438743co_vary
cowards1339613co_wards
cowbird1534433cowbird
cowhand1665933cowhand
cowherd1636953cowherd
crossarm1245133crossarm
cystoid13309213cystoid
dastards10278083dastards
discard11310213discard
dotards937253do_tards
eastward1244993eastward
forward1438293forward
foster94322223foster_
fostered122210453fostered
fosters104220103fosters
foulard11257283foulard
goliard936073goliard
hoard94918313ho__ard
holard10410573ho_lard
hosta85917833hosta__
hostage113111233hostage
hostas94515823hosta_s
hosted105020343host_ed
instar6310013instar_
instars7411133instars
jostled15267083jostled
leotard846193leotard
mortar83812043mortar_
mortared1137213mortared
mortars93411523mortars
mortary12369043mortary
mustards11297883mustards
mustardy14265053mustardy
notary92310713no_tary
octad81510653_octa_d
onward1039053_onward
osar46820953_os_ar_
ostiary1036463_ostiary
ostmark1344873_ostmark
ottar54313993_ottar_
ottars64112223_ottars
outadd837803_outadd
outward11811403_outward
petard95013803_petard
pochard1537363pochard
pollard103511143pollard
poniard1037583poniard
postage103214853postage
postal84317533posta_l
postals93716373postals
postcards1445733postcards
posted93722493post_ed
poster84129173poster_
postern93615613postern
posters93928013posters
postgrad1245493postgrad
postmark1645433postmark
postpaid1376543postpaid
posture9313253posture
postured1139493postured
postwar1236903postwar_
potshard1444533potshard
poulard10299733poulard
restart7320033restart
retard75018933_retard
ritard74812083_ritard
rosary92810353ros_ary
roster64329083roster_
rosters73727543rosters
rostra6310933rost_ra
rostral7311333rostral
rotary92411303ro_tary
sard55344243__s_ard
shard96125963__shard
staid66722083__staid
stand65923283__stand
star48037763__star_
stare54440263__stare
stared75429873__stared
stark95425623__stark
stars55836573__stars
start55642313__start
sward94221463__sward
tostada894953tostada
tostado895953tostado
toward10311063to_ward
unitard838003unitard
upstand1045343upstand
upstare9158683upstare
upstared11156573upstared
upstart9159753upstart
visard103910123vis_ard
vistaed1138023vistaed
votary12248333vo_tary
westward1543823westward
zoster153715853zoster_
zosters163015413zosters

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.400446727.5
2DLD Change Limit1340272226.20621596.4
3Display Results2222220.0762921.1
 (SQL Overall)1786912226.68226742.1
 
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.