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

98 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
repatterned145217(None) 
patterned1265742__patterned
repattern1143662repattern__
repatterns1242492repattern_s
bespattered1681723bespatter_ed
betattered1343143betatter_ed
pattened11299393__patte_ned
pattered112714203__patter_ed
rattened9218623r__atte_ned
realtered1037893re_alter_ed
reattained1144583re_attained
refastened1443933refaste_ned
regathered15124573regather_ed
relettered1144333reletter_ed
remastered1345643remaster_ed
repapered1445233repa_per_ed
repatterning1552173repatterning
replastered1442483replaster_ed
reuttered1036073re_utter_ed
spattered12187643_spatter_ed
attorned955364___attorned
battened11259574__batte_ned
battered113315054__batter_ed
bettered113011844be__tter_ed
blattered12198574_blatter_ed
chattered15197994_chatter_ed
clattered12178414_clatter_ed
dewatered1444744dewa_ter_ed
easterner945054_e_asterner
fattened12268284__fatte_ned
featherbed19174664fe_atherbed
feathered16188894fe_ather_ed
fettered12259494fe__tter_ed
flattened13185304_flatte_ned
flattered13188634_flatter_ed
gettered10258614ge__tter_ed
greatened1144584gre_a_te_ned
heartened1347064he_arte_ned
heathered16149464he_ather_ed
leathered13148714le_ather_ed
lettered92910784le__tter_ed
mattered112412904__matter_ed
nattered92011624__natter_ed
neatened937044ne_a_te_ned
paltered113012494__palter_ed
patterer103112174__patter_er
pattern93712054__pattern__
patterns10439944__pattern_s
pottered112311664__potter_ed
prealtered1344944pre_alter_ed
preattuned1342814pre_att_uned
puttered112611144__putter_ed
raftered1237664r__after_ed
rattener8238534r__atte_ner
rattooned1043844r__attooned
readorned1145184re_a_dorned
reasserted1145414re_asserted
reattached1643104re_attached
reattacked1743224re_attacked
reattempted1651564re_attempted
rebuttoned1351964rebutt_oned
recaptured1573594recaptur_ed
recautioned1483184recautioned
rechartered17153164recharter_ed
reearned948884reea___rned
reentered1038574re_enter_ed
refiltered1443774refilter_ed
registered1245294register_ed
rehammered1843084rehammer_ed
rehardened1543944reharde_ned
reinterred1145154re_interred
renatured1047294rena_tur_ed
repaired1148954repa__ir_ed
repaneled1245334repa_ne_led
repanelled1343404repa_nelled
reparked15208924repa___rked
repartee10312754reparte__e_
repartees1147254reparte__es
repasted112611534repast___ed
repatched1745314repa_t_ched
repatriated14114894repatriated
reperked15177794rep___erked
repetend1136224rep_ete_n_d
repotted1139284repott___ed
repowered1544664rep_ower_ed
resoftened1443414resofte_ned
restationed1244374restationed
returned9459134re___turned
rewakened1743444rewa_ke_ned
scattered12197354_scatter_ed
shattered13178204_shatter_ed
smattered12186784_smatter_ed
splattered13163944splatter_ed
sputtered12166324_sputter_ed
squattered2043254squatter_ed
tattered92011444__tatter_ed
weathered16168514we_ather_ed
yattered12239534__yatter_ed

Search took 9 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 Filter1786911488190.406440125.6
2DLD Change Limit148819988.48617537.0
3Display Results98980.0462130.4
 (SQL Overall)178691988.93819992.3
 
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.