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

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

87 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
repatterning155217(None) 
patterning1346072__patterning
bespattering1752343bespatter_ing
betattering1444143betatter_ing
pattering122314423__patter_ing
patternings1443183__patternings
rattening10288763r__atte_ning
realtering1139473re_alter_ing
reattaining1244593re_attaining
refastening1544303refaste_ning
regathering1645203regather_ing
relettering1255513reletter_ing
remastering1446843remaster_ing
repapering1547043repa_per_ing
repattern1143663repatter__n_
repatterned1452173repattern_ed
repatterns1242493repatter__ns
replastering1553413replaster_ing
reuttering1137573re_utter_ing
spattering13107793_spatter_ing
attorning1045504___attorning
battening12268854__batte_ning
battering122715144__batter_ing
bettering122212754be__tter_ing
blattering13108714_blatter_ing
chattering16108644_chatter_ing
clattering13109234_clatter_ing
dewatering1545774dewa_ter_ing
fattening13287834__fatte_ning
feathering17108794fe_ather_ing
fettering132310514fe__tter_ing
flattening14115104_flatte_ning
flattering1498744_flatter_ing
gettering112310034ge__tter_ing
greatening1245444gre_a_te_ning
heartening1446734he_arte_ning
leathering1488684le_ather_ing
lettering102112074le__tter_ing
mattering122314054__matter_ing
nattering102212214__natter_ing
neatening1038354ne_a_te_ning
paltering122612894__palter_ing
pottering122612004__potter_ing
prealtering1446174pre_alter_ing
preattuning1443044pre_att_uning
puttering122611644__putter_ing
rattooning1143954r__attooning
readorning1245724re_a_dorning
reasserting1246154re_asserting
reattaching1743124re_attaching
reattacking1843304re_attacking
reattempting1751654re_attempting
rebuttoning1452064rebutt_oning
recapturing1643764recaptur_ing
recautioning1553764recautioning
rechartering1853544recharter_ing
reearning1039054reea___rning
reentering1149984re_enter_ing
refiltering1544824refilter_ing
registering1346394register_ing
rehammering1953364rehammer_ing
rehardening1644144reharde_ning
reinterring1245364re_interring
renaturing11176804rena_tur_ing
repairing12310014repa__ir_ing
repaneling1345734repa_ne_ling
repanelling1443474repa_nelling
reparking1638924repa___rking
repasting122312834repast___ing
repatching1844994repa_t_ching
repatriating1545454repatriating
reperking1638704rep___erking
repotting12511124repott___ing
repowering1645274rep_ower_ing
resoftening1543234resofte_ning
restationing1354264restationing
returning1038134re___turning
rewakening1843794rewa_ke_ning
scattering1398014_scatter_ing
shattering1498284_shatter_ing
smattering1397584_smatter_ing
splattering1454544splatter_ing
sputtering13106464_sputter_ing
squattering2143804squatter_ing
tattering102212324__tatter_ing
weathering1798354we_ather_ing
yattering132410444__yatter_ing

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 Filter1786911247900.1561145455.1
2DLD Change Limit124790877.59316434.9
3Display Results87870.0461891.3
 (SQL Overall)178691877.79522923.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.