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

90 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
patchily188581(None) 
pitchily1855011pitchily
bitchily1844532bitchily
botchily1864372botchily
catchfly2143332catchfly
itchily1574492_itchily
patchier15319662patchier
patching163212752patching
patchouly1942922patchouly
patchy16509572patch__y
pithily1567032pit_hily
punchily1844862punchily
tetchily1644122tetchily
archil11611573_archil_
archils12510533_archils
archly1437353_arch_ly
batching163712093batching
blotchily1942683blotchily
bunchily1844543bunchily
catchall1546233catchall
catchier15329863catchier
catching163712773catching
catchy16559583catch__y
cattily123210853cat_tily
earthily1445613earthily
fancily1538253fanc_ily
fattily13379463fat_tily
gauchely1742743gauchely
hatchel153510753hatchel_
hatchels16368673hatchels
hatchery19326383hatchery
hatching173312213hatching
hatchway2243293hatchway
katchina1745333katchina
lacily11612763la_c_ily
latching143712023latching
latchkey2042913latchkey
matching163512393matching
nattily103610323nat_tily
pachisi14329523pa_chisi
pacify1667473pa_c_ify
packly17228333pa_c_kly
paltrily1345413paltrily
parching164313053parching
parchisi15368933parchisi
paschal14157243paschal_
paschals1566473paschals
patch125221223patch___
patchable1845633patchable
patched153514623patch_ed
patcher143515143patch_er
patchers153413303patchers
patches143320383patch_es
patchiest1638353patchiest
patchouli1652673patchouli
patently1347113patently
pathway1844853pat_hway
patly105020583pat___ly
patronly1344883patronly
paucity1435823pauc_ity
pawkily1934203pa_wkily
pettily1238173pet_tily
pitchier15368273pitchier
pitching163411113pitching
pitchy16479673pitch__y
pluckily1963413pluckily
plushily1664423plushily
pockily1846233p_ockily
preachily1945143preachily
prechill1546193prechill
pricily142710283pric_ily
pushily15247983p_ushily
racily11715173ra_c_ily
raunchily1742813raunchily
satchel123310303satchel_
satchels13328163satchels
saucily1237913sauc_ily
scratchily2042553scratchily
sketchily2142333sketchily
starchily1745013starchily
tackily1637503ta_ckily
tattily10409993tat_tily
techily1537123_techily
touchily1645233touchily
twitchily2052193twitchily
wackily1936053wa_ckily
watchcry2142363watchcry
watching173011173watching
waterily1438783waterily
wrathily1744773wrat_hily

Search took 10 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 Filter1786911461620.313570897.8
2DLD Change Limit146162908.70316794.4
3Display Results90900.0303000.0
 (SQL Overall)178691909.04619753.6
 
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.