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

221 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
whacko1847703(None) 
shacko153810111shacko
wacko145514381w_acko
whack174813021whack_
whackos19375261whackos
whacks184610481whacks
whacky21556491whacky
hack135134542_hack_
hacks144928712_hacks
shack145321752shack_
shackos16429022shackos
shacks154817562shacks
shako125516092sha_ko
thack144915172thack_
thacks154311922thacks
wack135330912w_ack_
wacke145918622w_acke
wackos155210992w_ackos
wacks146626282w_acks
wacky174714932w_acky
whacked20458622whacked
whacker19368502whacker
whammo16405192whammo
whamo135511262wha_mo
wrack145413882wrack_
wracks154711112wracks
aback134816173aback_
alack114820063alack_
back125535763_back_
backs135729623_backs
black134719073black_
blacks144914953blacks
bucko134614023_bucko
cacao95420003_cacao
chachka21173643chachka
chacma1537903chacma
chalk144814603chalk_
chalks155412143chalks
chalky18468773chalky
chao95727313cha__o
chark144222713chark_
charka154011703charka
charks155219703charks
charro114212953charro
check164714713check_
checks174912703checks
chick165419133chick_
chicks175317593chicks
chico124218253chic_o
chock164316613chock_
chocks174815313chocks
chuck164814873chuck_
chucks174812933chucks
chucky20418003chucky
clack134720173clack_
clacks144516343clacks
crack134120533crack_
cracks144817003cracks
cracky175010223cracky
dhak125512033dha_k_
dhaks13479703dha_ks
flack144519413flack_
flacks154114533flacks
gecko124511113_gecko
guaco85012163guac_o
hacek145411843_hacek
haceks15447863_haceks
hacked164923513_hacked
hackee154921833_hackee
hacker154822693_hacker
hackie154615623_hackie
hackle154916813_hackle
hackly18298733_hackly
haik115526983_haik_
haika125313793_haika
haiks125120933_haiks
haiku126113693_haiku
hake115637843_ha_ke
haku116923893_ha_ku
hallo85127553_hallo
halo76437323_ha_lo
hank115134143_hank_
hanks126226863_hanks
hanky155418293_hanky
hao67251123_ha__o
hark115237393_hark_
harks126333433_harks
hawk145521153_hawk_
hawks155415703_hawks
heck135826493_heck_
hecks145220653_hecks
hick135530303_hick_
hicks145322173_hicks
hock136031303_hock_
hocks144925493_hocks
huck135927633_huck_
hucks144322173_hucks
jack175224863_jack_
jacks185219833_jacks
jacky215412343_jacky
jocko184210453_jocko
khaki1157643kha_ki
knack104311043knack_
knacks11428543knacks
kyack13468263kyack_
kyacks14416063kyacks
lack105837683_lack_
lacks116129203_lacks
macho126120153_macho
mack125733653_mack_
macks135127603_macks
macro94718173_macro
mako105622363_ma_ko
nacho105414383_nacho
pack125535443_pack_
packs135528933_packs
plack135017843plack_
placks144414153placks
quack203812503quack_
quacks214710103quacks
quacky24376963quacky
rack106234883_rack_
racks115028853_racks
sack105337313_sack_
sacks114228873_sacks
shacked174015393shacked
shackle16409543shackle
shackoes17367853shackoes
shake124726403sha_ke
shakos134912193sha_kos
shaky154616843sha_ky
shank125422193shank_
shanks135315583shanks
shark126225023shark_
sharks135019723sharks
shock144917033shock_
shocks154414583shocks
shuck144314533shuck_
shucks154010413shucks
sicko115315393_sicko
slack115021763slack_
slacks124416533slacks
smack134615453smack_
smacks144112323smacks
snack114718063snack_
snacks124514553snacks
socko115215113_socko
stack114421693stack_
stacks124317263stacks
tack106536293_tack_
tacks115430133_tacks
tacky145617443_tacky
taco67031353_tac_o
thacked173810203thacked
thank125817803thank_
thanks134313133thanks
thick145613353thick_
thicks154511993thicks
thwack1834213thwack_
thwacks1953613thwacks
track114823013track_
tracks124818843tracks
wacker154920123w_acker
wackes154717713w_ackes
wahoo112413083w_ahoo
wake114935703w_a_ke
walk115625613w_alk_
walks126218503w_alks
wank115632513w_ank_
wanks126124483w_anks
wark115737773w_ark_
warks127932403w_arks
wauk115220593w_auk_
wauks125515163w_auks
wazoo173011173w_azoo
weak117126303wea_k_
weakon13357623wea_kon
wha96422073wha___
whackers20326543whackers
whackier2044673whackier
whacking21377483whacking
whale115517433wha_le
whaled134612033whaled
whaler124611973whaler
whales124716943whales
wham125321693wha__m
whammy19375293whammy
whams135515643wha_ms
whang124813383wha_ng
whangs13439723whangs
whap125119643wha__p
whaps135115163wha_ps
wharf14315823wha_rf
wharfs1546373wharfs
wharve15456203wharve
what105434073wha__t
whatnot1344733whatnot
whats117718993wha_ts
whaup13458883wha_up
whaups14405753whaups
whelk154311063whelk_
whelks16367323whelks
whelky19314973whelky
which163910083whic_h
whicker19359773whicker
whisk154510143whisk_
whisks16497353whisks
whisky19455903whisky
who95526773wh___o
whomso1434133whomso
whoso11509223wh_oso
wick135726303w_ick_
wicks144619363w_icks
wilco1039443wilc_o
wracked174110113wracked
wreck144611043wreck_
wrecks15418883wrecks
wrick144013393wrick_
wricks154610623wricks
yack135425973_yack_
yacks144419813_yacks

Search took 6 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 Filter1786911127160.406440125.6
2DLD Change Limit1127162215.42320784.8
3Display Results2212210.0633507.9
 (SQL Overall)1786912215.89230327.7
 
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.