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

85 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
snatchier145535(None) 
snatcher13167761snatch_er
catchier15329862_catchier
patchier15319662_patchier
scratchier1744342scratchier
sketchier1853412sketchier
smutchier1643502smutchier
snatched14157632snatch_ed
snatchers14146312snatch_ers
snatches131410712snatch_es
snatchiest1545152snatchiest
snatching1536362snatching
snitcher13157372snitch_er
starchier1436642starchier
thatchier1743982thatchier
achier113914263__a_chier
anarchies1448183anarchies
batcher144414853_batch_er
beachier1538803bea_chier
bitchier15307733_bitchier
blotchier1643213blotchier
botchier15287143_botchier
branchier1637133branchier
catcher143115823_catch_er
glitchier1542793glitchier
gnattier934263gnat_tier
hatcher153314723_hatch_er
heathier1438343heat_hier
itchier12247673__itchier
kvetchier2141863kvetchier
lathier10310833_lat_hier
leachier1337253lea_chier
matcher143214283_match_er
nattier73614623_nat_tier
nitchie1247233_nitchie_
nitchies1339073_nitchies
notcher123610933_notch_er
patcher143515143_patch_er
peachier1548623pea_chier
pitchier15368273_pitchier
poachier1556823poa_chier
satchel123310303s_atch_el
saucier9810283s_auc_ier
scattier10267583scat_tier
scratcher1635443scratch_er
scutcher15176963scutch_er
searcher13209103search_er
sketcher1735433sketch_er
slatches131511523slatch_es
slather103816073slat_h_er
slatier74016813slat__ier
slouchier1443603slouchier
snacker133112603sna_c_ker
snaggier10136303sna_ggier
snakier112810003sna__kier
snappier1266213sna_ppier
snarkier12336513sna_rkier
snarlier8278183sna_rlier
snatch114310603snatch___
snatchy15355293snatch__y
snathe94415113snat_h_e_
snathes104816493snat_h_es
snazzier1642483sna_zzier
snitched14166863snitch_ed
snitchers14166043snitch_ers
snitches13148983snitch_es
snitching1535913snitching
snottier8217383snot_tier
spacier114011633spa_c_ier
splotchier1741933splotchier
stancher13198813stanch_er
statelier945653statelier
stenchier1445333stenchier
stitcher13168393stitch_er
stretchier1544483stretchier
swarthier1543783swarthier
swatches16169963swatch_es
swather134213603swat_h_er
switcher16177683switch_er
tetchier1336453_tetchier
thatcher1635663thatch_er
twitchier1753233twitchier
watcher153113403_watch_er
witchier16307883_witchier
wrathier1435903wrat_hier

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 Filter1786911486410.423422437.4
2DLD Change Limit148641857.40620070.3
3Display Results85850.0461847.8
 (SQL Overall)178691857.87522690.9
 
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.