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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
thwacking225319(None) 
thacking183110041th_acking
hacking173720612_h_acking
shacking184014082sh_acking
tacking144421482t__acking
thanking16409522th_anking
thwarting1632762thwarting
tracking153715462t_racking
whacking21377482wh_acking
attacking1635323attacking
awaking1547813_awa_king
backing165523443__backing
blacking174213603_blacking
chalking183310063ch_alking
charking183512613ch_arking
checking20379203ch_ecking
chocking204011013ch_ocking
chucking20379503ch_ucking
clacking173313493_clacking
cracking174013903_cracking
flacking184311793_flacking
hackling183310163_h_ackling
hanking154619103_h_anking
harking154120943_h_arking
hawking183711423_h_awking
hijacking2642763hijacking
hocking173417243_h_ocking
hoicking1836053_hoicking
jacking214515263__jacking
knacking14296713_knacking
lacking143821543__lacking
packing164420723__packing
quacking2436743_quacking
racking144323663__racking
repacking1838283repacking
reracking1639313reracking
retacking1658973retacking
rewaking162310983rewa_king
sacking144122703__sacking
shackling19286173sh_ackling
shaking153317253sh_a_king
shanking163612283sh_anking
sharking163912973sh_arking
shocking184311543sh_ocking
shucking18339433sh_ucking
slacking153914133_slacking
smacking173510763_smacking
snacking153411703_snacking
stacking154215083_stacking
swanking16399963_swanking
tackling153211123t__ackling
taking114725953t__a_king
talcking1567083t_alcking
talking123815823t__alking
tanking123918793t__anking
tarmacking1944233tarmacking
tasking124616323t__asking
teaching143612603t_eaching
thatching1835143thatching
thawing14378683th_a_wing
thinking16289863th_inking
thralling13256833thralling
thrashing1635683thrashing
thrawing1535963thra_wing
thunking16196953th_unking
thwack1834213thwack___
thwacked2132723thwack_ed
thwacker2042873thwack_er
thwackers2142223thwackers
thwacks1953613thwack__s
ticking143218753t__icking
tictacking19113313tictacking
tracing103720153t_rac_ing
trackings16247543t_rackings
traiking132511973t_raiking
tricking152714513t_ricking
troaking133310973troa_king
trocking153612423t_rocking
trucking153310163t_rucking
tucking143415183t__ucking
twanging13287063t_wanging
tweaking1635883t_weaking
unpacking1835133unpacking
untacking1636643untacking
waking144821383__wa_king
walking154013303__walking
wanking154216783__wanking
warking153519573__warking
wauking153410013__wauking
wicking173414773__wicking
wracking18349963_wracking
yacking174315683__yacking

Search took 7 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 Filter1786911486410.453394461.4
2DLD Change Limit148641925.93625040.6
3Display Results92920.0332787.9
 (SQL Overall)178691926.42227824.8
 
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.