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

148 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
thwacks195361(None) 
thacks154311921th_acks
thwack1834211thwack_
hacks144928712_h_acks
shacks154817562sh_acks
tacks115430132t__acks
thack144915172th_ack_
thanks134313132th_anks
thicks154511992th_icks
thwacked2132722thwacked
thwacker2042872thwacker
thwackers2142222thwackers
thwarts1345022thwarts
towsacks1744172towsacks
tracks124818842t_racks
wacks146626282__wacks
whacks184610482wh_acks
arracks1387733arracks
attacks13126943attacks
backs135729623__backs
bipacks1745043bipacks
blacks144914953_blacks
caracks152211563caracks
chalks155412143ch_alks
charks155219703ch_arks
checks174912703ch_ecks
chicks175317593ch_icks
chocks174815313ch_ocks
chucks174812933ch_ucks
clacks144516343_clacks
cracks144817003_cracks
dhaks13479703dh_a_ks
flacks154114533_flacks
haceks15447863_h_aceks
hack135134543_h_ack_
haiks125120933_h_aiks
hanks126226863_h_anks
harks126333433_h_arks
hawks155415703_h_awks
hecks145220653_h_ecks
hicks145322173_h_icks
hijacks2333533hijacks
hocks144925493_h_ocks
hoicks15378283_hoicks
hucks144322173_h_ucks
jacks185219833__jacks
knacks11428543_knacks
kyacks14416063_kyacks
lacks116129203__lacks
macks135127603__macks
packs135528933__packs
placks144414153_placks
quacks214710103_quacks
racks115028853__racks
repacks15269543repacks
reracks132310533reracks
retacks132210713retacks
sacks114228873__sacks
shack145321753sh_ack_
shacko153810113sh_acko
shackos16429023sh_ackos
shanks135315583sh_anks
sharks135019723sh_arks
shlocks16317183shlocks
shmucks1833943shmucks
shocks154414583sh_ocks
shticks16356963shticks
shucks154010413sh_ucks
shwas116415103shwa__s
slacks124416533_slacks
smacks144112323_smacks
snacks124514553_snacks
stacks124317263_stacks
swanks134811563_swanks
taces76237803t__aces
tachs105820933t__achs
tack106536293t__ack_
tacky145617443t__acky
tacos77023553t__acos
tacts76524123t__acts
talks94322693t__alks
tanks94624733t__anks
tasks94917583t__asks
teaks94222903t_ea_ks
tenaces92814513tenaces
thacked173810203th_acked
thanes94918983th_anes
thank125817803th_ank_
tharms115712243th_arms
thawers13428483thawers
thaws116515463th_a_ws
thick145613353th_ick_
thinks134613363th_inks
thoraces13118943thoraces
thralls10299043thralls
thraves13469713thraves
thraws129211103thra_ws
throwbacks24734583throwbacks
thunks13459033th_unks
thwacking2253193thwacking
thwart12311683thwa_rt
ticks115823293t__icks
tiebacks1646333tiebacks
tilaks1097353tila_ks
tombacks18216463tombacks
towages1139233towages
towards1138783towards
towsack1644723towsack_
traces85329933t_races
track114823013t_rack_
tracts85019073t_racts
traiks104013713t_raiks
tranks104017763t_ranks
triacs83913223triac_s
tricks125319013t_ricks
tripacks1664893tripacks
troaks104410603troa_ks
trocks123614633t_rocks
trucks124711973t_rucks
tucks114721123t__ucks
turacos938643turacos
twaes86513663t_wa_es
twains95811183t_wains
twangs10358093t_wangs
twanky16445773t_wanky
twas76824083t_wa__s
twats86616603t_wa_ts
tweaks1335963t_weaks
umiacks1534013umiacks
unpacks1576093unpacks
untacks1357503untacks
wack135330913__wack_
wacke145918623__wacke
wackes154717713__wackes
wacko145514383__wacko
wackos155210993__wackos
wacky174714933__wacky
walks126218503__walks
wanks126124483__wanks
warks127932403__warks
wauks125515163__wauks
whack174813023wh_ack_
whacko18477033wh_acko
whackos19375263wh_ackos
whacky21556493wh_acky
wicks144619363__wicks
wracks154711113_wracks
yacks144419813__yacks

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.406440125.6
2DLD Change Limit1340271486.87319500.5
3Display Results1481480.0502960.0
 (SQL Overall)1786911487.32924381.4
 
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.