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

169 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
thwack183421(None) 
thack144915171th_ack
thwacks1953611thwacks
hack135134542_h_ack
shack145321752sh_ack
tack106536292t__ack
thacks154311922th_acks
thank125817802th_ank
thick145613352th_ick
thwacked2132722thwacked
thwacker2042872thwacker
thwart12311682thwart
towsack1644722towsack
track114823012t_rack
wack135330912__wack
whack174813022wh_ack
aback134816173_aback
alack114820063_alack
arrack121110253arrack
athwart1348683athwart
attack12148153attack
back125535763__back
bipack1636523bipack
black134719073_black
carack142113173carack
chalk144814603ch_alk
chark144222713ch_ark
check164714713ch_eck
chick165419133ch_ick
chock164316613ch_ock
chuck164814873ch_uck
clack134720173_clack
crack134120533_crack
dhak125512033dh_a_k
flack144519413_flack
hacek145411843_h_acek
hacks144928713_h_acks
haik115526983_h_aik
hank115134143_h_ank
hark115237393_h_ark
hawk145521153_h_awk
heck135826493_h_eck
hick135530303_h_ick
hijack2233673hijack
hock136031303_h_ock
hoick145210683_hoick
huck135927633_h_uck
hwan105716893_hwa_n
jack175224863__jack
knack104311043_knack
kyack13468263_kyack
lack105837683__lack
mack125733653__mack
pack125535443__pack
plack135017843_plack
quack203812503_quack
rack106234883__rack
repack142412163repack
rerack122513163rerack
retack122612823retack
sack105337313__sack
shacko153810113sh_acko
shacks154817563sh_acks
shank125422193sh_ank
shark126225023sh_ark
shlock15378193shlock
shmuck1734243shmuck
shock144917033sh_ock
shrank13359123shrank
shtick15308023shtick
shuck144314533sh_uck
shwa106014963shwa__
shwas116415103shwa_s
slack115021763_slack
smack134615453_smack
snack114718063_snack
stack114421693_stack
swank125318233_swank
tace65342513t__ace
tach96132753t__ach
tacks115430133t__acks
tacky145617443t__acky
taco67031353t__aco
tact67349033t__act
talk86230093t__alk
tank85134023t__ank
task85326653t__ask
teach105221123t_each
teak85930843t_ea_k
tenace82715693tenace
thacked173810203th_acked
thae76825563th_a_e
than76128773th_a_n
thane86122533th_ane
thanks134313133th_anks
tharm105916643th_arm
that75639323th_a_t
thatch1435613thatch
thaw107521313th_a_w
thawed13458463thawed
thawer12489343thawer
thaws116515463th_aws
theca103311453th_eca
thecae11299653thecae
thecal113310303thecal
thence112010843thence
thicks154511993th_icks
think125018803th_ink
thrall93810293thrall
thrash12258363thrash
thrave126010273thrave
thraw1110515923thra_w
thrawn12769423thrawn
thraws129211103thraws
thrice114311573thrice
throwback231934833throwback
thunk124911853th_unk
thwackers2142223thwackers
thwacking2253193thwacking
thwarts1345023thwarts
tick106231223t__ick
tieback1547103tieback
tilak91011553tila_k
tomback17227743tomback
towage1039833towage
toward10311063toward
towsacks1744173towsacks
trace75829613t_race
tracks124818843t_racks
tract75635713t_ract
traik95418203t_raik
trank96222423t_rank
triac74116373triac_
triacs83913223triacs
trick115420693t_rick
tripack1565673tripack
troak95213573troa_k
trock114817603t_rock
truck116115463t_ruck
tuck104626573t__uck
turaco839453turaco
twa67721643t_wa__
twae74719573t_wa_e
twaes86513663t_waes
twain86313623t_wain
twang94511853t_wang
twanky16445773t_wanky
twas76824083t_wa_s
twat75831513t_wa_t
twats86616603t_wats
tweak1257753t_weak
twice104711123t_wice
umiack1435173umiack
unpack1457833unpack
untack1239763untack
wacke145918623__wacke
wacko145514383__wacko
wacks146626283__wacks
wacky174714933__wacky
walk115625613__walk
wank115632513__wank
wark115737773__wark
wauk115220593__wauk
whacko18477033wh_acko
whacks184610483wh_acks
whacky21556493wh_acky
wick135726303__wick
wrack145413883_wrack
yack135425973__yack

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.373479064.3
2DLD Change Limit1127161694.86023192.6
3Display Results1691690.0632682.5
 (SQL Overall)1786911695.29633740.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.