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

182 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
discard1131021(None) 
discards1238911discards
discord1139991discord
dastard9279702dastard
diehard1237052diehard
disarm9310472dis_arm
disband1138242disband
disbar938512disbar_
disbars10310322disbars
discant103017262discant
discarded1437082discarded
discarder1346752discarder
discase102912862discase
discased122510852discased
disced104914652disc_ed
discern1038492discern
discoed11312482discoed
discoid11311242discoid
discords1238592discords
dispart101115282dispart
piscary1437422piscary
visard103910122vis_ard
airward1148133airward
ascared10399523_ascared
ascarid103910723_ascarid
bastard103012423bastard
bicarb1238543bi_carb
bustard10389723bustard
card710245873___card
cascara1138313cascara
costard104113353costard
custard10389973custard
dastards10278083dastards
daycare1355093daycare
debeard1137353debeard
decare93919153d_ecare
desand84812633des_and
descant104315593descant
descend11248153descend
descry1256183desc_ry
diacid10310633diac_id
diary95016973di__ary
dicast9315573di_cast
diced95824683di_c_ed
dicer85426423di_cer_
dicers94720743di_cers
dicked144920863di_cked
diehards1346213diehards
dietary1158663dietary
dinar66319893di_nar_
dinars75417563di_nars
disaccord1552623disaccord
disarmed1238643dis_armed
disarms1039043dis_arms
disbands1237353disbands
disbarred1345283disbarred
disbud10165713dis_bud
disc76123243disc___
discalced1545653discalced
discanted1339333discanted
discants112912023discants
discarders1445043discarders
discarding1547343discarding
discases112014503discases
discept12310623discept
discerned1347863discerned
discerns1138163discerns
discharge1664843discharge
discharged1864453discharged
disci85815023disc__i
discing113914593discing
disclaim1345643disclaim
disco85616073disc__o
discoids1239873discoids
discorded1438133discorded
discos94915213disc_os
discs85316263disc__s
discus94512113disc_us
discuss10357953discuss
disdain938513disdain
disease83213843disease
diseased103011713diseased
diseur738843diseur_
diseurs839403diseurs
dished114318713dis_hed
dishrag1246273dishrag
dishware1545433dishware
disked125015763dis_ked
dismal92412243disma_l
dismals102010243dismals
dismast10311233dismast
dismay12229473disma_y
dismayed1535743dismayed
dismays13237433dismays
disparted1338853disparted
disparts11109953disparts
dispend11289413dispend
disport101015953disport
disrate81418523disrate
disrated10915573disrated
disregard1243253disregard
dissave1139413dissave
dissaved1337313dissaved
dissed85220183dis_sed
dissert83720693dissert
distaff1467683distaff
distain8313783distain
distal73615773dista_l
distant83519953distant
distend93312073distend
distort81120333distort
disturb1046233disturb
disused93211033disused
ditched143711903ditched
dogcart1148043dogcart
dotard839053d_otard
dullard936603dullard
escar74011993_escar_
escarp10449003_escarp
escars83913133_escars
filmcard1642823filmcard
fiscal1139333fisca_l
fiscals1238003fiscals
gizzard17114203gizzard
guisard954203guis_ard
inward10310333_inward
island738533_island
izzard15135243_izzard
keycard1743663keycard
lascar868573lascar_
lascars979013lascars
liard65418593li__ard
lizard16369233li_zard
mascara1138023mascara
misadd1037163mis_add
misaward1464593misaward
miscall1139653miscall
miscarry1544473miscarry
miscast11312423miscast
miscued1239293miscued
misheard1446253misheard
mislaid1039303mislaid
mismark1536703mismark
mispart111113783mispart
missaid10310303missaid
misword1338413misword
mustard10359533mustard
nicad8312613ni_ca_d
niggard1044943niggard
picara10311903pi_cara
picaro10311323pi_caro
pilchard1644553pilchard
placard1236783placard
postcard1346523postcard
ripcord1264463ripcord
ritard74812083ri_tard
sard55344243__s_ard
scad75725773__sca_d
scald84818123__scald
scar66434203__scar_
scare75334463__scare
scared95227293__scared
scarf105427143__scarf
scarp95724103__scarp
scars75433533__scars
scart76139773__scart
scary105222593__scary
shard96125963__shard
sward94221463__sward
timecard1343993timecard
tipcart1148833tipcart
vicar10513863vi_car_
vicars11712263vi_cars
visaed104110503vis_aed
visards11328153vis_ards
viscera1235083viscera
viscid1237473visc_id
viscoid1337023viscoid
vistaed1138023vistaed
vizard19458853vi_zard
wildcard1543643wildcard
wizard19377713wi_zard

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.466383457.1
2DLD Change Limit1340271826.87619492.0
3Display Results1821820.0632888.9
 (SQL Overall)1786911827.40524131.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.