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

140 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
wacke14591862(None) 
wack135330911wack_
wacker154920121wacker
wackes154717711wackes
wacko145514381wacko
wacks146626281wacks
wacky174714931wacky
wake114935701wa_ke
ace59656832_ac_e
ache96829822_ache
ackee115825372_ackee
acme86924322_acme
acne66625872_acne
acre67330772_acre
awake125014782awake
awoke124912002awoke
back125535762back_
backed155725722backed
backer144525522backer
backs135729622backs
bake105637512ba_ke
cache125122482cache
cackle143416922cackle
cake105439962ca_ke
dace76934922dac_e
dacker134920752dacker
face96140122fac_e
fake115534942fa_ke
hacek145411842hacek
hack135134542hack_
hacked164923512hacked
hackee154921832hackee
hacker154822692hacker
hackie154615622hackie
hackle154916812hackle
hacks144928712hacks
hake115637842ha_ke
jack175224862jack_
jacked204817522jacked
jacker194417582jacker
jacket194720672jacket
jacks185219832jacks
jacky215412342jacky
jake155925772ja_ke
lace66848472lac_e
lack105837682lack_
lacked135324652lacked
lacker125325622lacker
lackey154813352lackey
lacks116129202lacks
lake85741602la_ke
latke94817092latke
mace87345792mac_e
mache125925302mache
mack125733652mack_
mackle143716432mackle
macks135127602macks
macle96127002macle
make105537892ma_ke
nacre75715362nacre
pace86345772pac_e
pack125535442pack_
packed154822602packed
packer144223402packer
packet144726502packet
packs135528932packs
race66746262rac_e
rack106234882rack_
racked134526082racked
racker124824552racker
racket125229422racket
rackle123917292rackle
racks115028852racks
rake84841572ra_ke
sack105337312sack_
sacked135525212sacked
sacker125124842sacker
sacks114228872sacks
sake85244962sa_ke
swacked173110522swacked
tace65342512tac_e
tache106222372tache
tack106536292tack_
tacked134723942tacked
tacker124224502tacker
tacket124627492tacket
tackey154613082tackey
tackle123815732tackle
tacks115430132tacks
tacky145617442tacky
take84739262ta_ke
wackest164710862wackest
wackier16369732wackier
wackos155210992wackos
wade85237062wa_de
wae67556952wa__e
wage84834082wa_ge
waive114214602waive
waked135626752wa_ked
waken124818472wa_ken
waker125526592wa_ker
wakes126633652wa_kes
wale74546432wa_le
walk115625612walk_
walked145313782walked
walker133913992walker
walks126218502walks
wame95035482wa_me
wane76344722wa_ne
wank115632512wank_
wanked144517152wanked
wanker134219972wanker
wanks126124482wanks
ware76254722wa_re
wark115737772wark_
warked144421212warked
warks127932402warks
waste86125052waste
wauk115220592wauk_
wauked144210572wauked
wauks125515162wauks
wave105234732wa_ve
whack174813022whack_
whacked20458622whacked
whacker19368502whacker
whacko18477032whacko
whacks184610482whacks
whacky21556492whacky
wick135726302wick_
wicked164317412wicked
wicker154518672wicker
wicket155318942wicket
wicks144619362wicks
woke115527962w_oke
wrack145413882wrack_
wracked174110112wracked
wracks154711112wracks
yack135425972yack_
yacked164516792yacked
yacks144419812yacks

Search took 3 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 Filter178691538000.360496363.9
2DLD Change Limit538001401.86028924.7
3Display Results1401400.0463043.5
 (SQL Overall)1786911402.26678857.5
 
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.