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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

158 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
talked11401540(None) 
balked135219411balked
calked134617401calked
stalked123811171stalked
tacked134723941tacked
talced93811001talced
talcked1446341talcked
talker103916221talker
tanked113919291tanked
tasked114714641tasked
walked145313781walked
alkyd13537092_alkyd
asked106919312_asked
backed155725722backed
baked126130772ba_ked
balded105417512balded
baled85436442bal_ed
balker124519162balker
balled94926892balled
banked135021442banked
barked135027312barked
basked135218602basked
baulked14465622baulked
bilked134012942bilked
bulked134216742bulked
caked126128622ca_ked
calker124917082calker
called94126732called
calmed114816382calmed
calved125215452calved
carked134024822carked
casked134815512casked
caulked14486672caulked
chalked17449862chalked
darked123919632darked
faked135225482fa_ked
flaked144715652flaked
galled84622852galled
gawked15468762gawked
hacked164923512hacked
haled95335822hal_ed
haloed104717592haloed
halted105019602halted
halved134813902halved
hanked144220602hanked
harked145422552harked
hawked174712672hawked
holked144913662holked
hulked144611302hulked
jacked204817522jacked
jauked18489012jauked
lacked135324652lacked
laked105731122la_ked
lalled74218752lalled
larked114519472larked
malfed12369752malfed
malled94626102malled
malted94819852malted
marked133921622marked
masked134316522masked
milked134612572milked
naked105320852na_ked
naled65525052nal_ed
narked114116742narked
packed154822602packed
paiked135113432paiked
paled85538722pal_ed
palled94625162palled
palmed114314642palmed
palped114513642palped
parked134425132parked
racked134526082racked
raked105831422ra_ked
ranked114620742ranked
sacked135525212sacked
salted74121202salted
salved103916422salved
silked114314812silked
slaked114318272slaked
stacked143416122stacked
staked114621942sta_ked
staled74728102stal_ed
stalker113912252stalker
stalled83515682stalled
sulked114314702sulked
tabbed114215362tabbed
tabled94020042tabled
tabued94310402tabued
tacker124224502tacker
tacket124627492tacket
tackey154613082tackey
tackled143913182tackled
tagged93418122tagged
tailed74424662tailed
take84739262ta_ke_
taken94819142ta_ken
taker95229002ta_ker
takes94437792ta_kes
tale46154162tal_e_
taler56034862tal_er
tales55451372tal_es
taliped1078202taliped
talk86230092talk__
talkers113513212talkers
talkie103914442talkie
talkier114011842talkier
talkies113415732talkies
talks94322692talk_s
talky126215682talk_y
taller63721962taller
tallied83314752tallied
taloned8310222taloned
tamed85528512ta_med
tamped114317042tamped
tanged84622492tanged
tanker104521122tanker
tanned75219952tanned
taped85327422ta_ped
tapped113820052tapped
tared69340052ta_red
tarred74720282tarred
tarted74923372tarted
tasted74123972tasted
tatted74920532tatted
tauted75317112tauted
tawed95926192ta_wed
tawsed10499742tawsed
taxed135620292ta_xed
taxied14509372taxied
thacked173810202thacked
thanked15469152thanked
ticked134720522ticked
tiled64832942til_ed
tilled74722952tilled
tilted74616862tilted
toked105626492t_oked
toled65934922tol_ed
tolled73819032tolled
tracked143716132tracked
traiked123310452traiked
troked114114582troked
tsked105910032t_sked
tucked134017492tucked
tusked114112152tusked
uptalked1533052uptalked
valued104011152valued
valved136711042valved
waked135626752wa_ked
waled94330992wal_ed
walker133913992walker
walled104021292walled
wanked144517152wanked
warked144421212warked
wauked144210572wauked
yacked164516792yacked
yakked13366092yakked
yanked144312242yanked
yolked14367152yolked

Search took 4 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 Filter178691825510.1101624463.6
2DLD Change Limit825511582.98627646.0
3Display Results1581580.0602633.3
 (SQL Overall)1786911583.15656619.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.