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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

157 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
patternings144318(None) 
patterning1346071patterning_
pattering122314422patter_ing_
attendings12143523_attendings
attorning1045503_attorning_
battening12268853batte_ning_
battering122715143batter_ing_
fastenings14273903faste_nings
fattening13287833fatte_ning_
gatherings15105293gather_ings
gutterings12224913gutter_ings
letterings11226003letter_ings
mattering122314053matter_ing_
nattering102212213natter_ing_
paltering122612893palter_ing_
patternless1342283patternless
patterns10439943patter__n_s
plasterings1444743plaster_ings
pottering122612003potter_ing_
puttering122611643putter_ing_
rattening10288763ratte_ning_
repatterning1552173repatterning_
scatterings14103973scatter_ings
smatterings14103843smatter_ings
spattering13107793spatter_ing_
tattering102212323tatter_ing_
waterings13229253wa_ter_ings
yattering132410443yatter_ing_
altering91917114_alter_ing_
alternants1055114_alternants
athelings1345114_athe_lings
attaining1047224_attaining_
attending11136374_attending_
attesting1036384_attesting_
attiring939484_attir_ing_
attuning935904_att_uning_
bacterins13410644bacter_in_s
bantering122414234banter_ing_
bartering122313644barter_ing_
batteries11615114batter_i_es
battings114010574batt___ings
bettering122212754better_ing_
bittering122511994bitter_ing_
blattering13108714blatter_ing_
buttering122312524butter_ing_
cantering122417374canter_ing_
cartoonings1442664cartoonings
catering112019904ca_ter_ing_
catteries11815524catter_i_es
caverning1536284ca_verning_
centerings13247664center_ings
chattering16108644chatter_ing_
chitterlings1851414chitterlings
clattering13109234clatter_ing_
craterings1346004crater_ings
darnings10378554da___rnings
earnings9419334ea___rnings
faltering132211114falter_ing_
fastening13268604faste_ning_
fathering161010094father_ing_
featherings18105374feather_ings
fettering132310514fetter_ing_
flattening14115104flatte_ning_
flattering1498744flatter_ing_
fosterlings1542854fosterlings
gartering112111574garter_ing_
gathering1499464gather_ing_
gettering112310034getter_ing_
guttering112410444gutter_ing_
haltering132212004halter_ing_
hankerings18244754hanker_ings
happenings1842624happe_nings
hardenings1544244harde_nings
hastening13259484haste_ning_
hatterias1258744hatter_i_as
interning10315254_interning_
jittering17218424jitter_ing_
kittening1434594kitte_ning_
latening9711494la_te_ning_
lathering13912254lather_ing_
latticings1342844latt_icings
lawyerings1752584lawyer_ings
layerings13235684la_yer_ings
lettering102112074letter_ing_
littering102411984litter_ing_
mastering122315304master_ing_
masterminds16102414masterminds
mattings11369674matt___ings
motherings16255644mother_ings
muttering122611324mutter_ing_
oysterings1443904oyster_ings
pairings11398314pa__ir_ings
pampering1638384pamper_ing_
pandering133211964pander_ing_
panelings12107454pa_ne_lings
panellings1344534pa_nellings
papering132213314pa_per_ing_
parentings1355614pa_rentings
pargetings1443714parge_tings
pargings123410164pa___rgings
parings104219214pa___r_ings
parkings153610684pa___rkings
partings113513734pa___rtings
partnering1345554partner_ing_
passerines1246164passer_ines
pasterns104112624paster__n_s
pastoring12310854pastor_ing_
pasturing1238434pastur_ing_
patenting1248944pa_tenting_
paternities1345784pa_ternities
paternity1444834pa_terni_ty
pathfindings2261134pathfindings
patining11312304pa_t_ining_
pattens95414924patte___n_s
patterers112410124patter__ers
pattern93712054patter__n__
patterned1265744patter__ned
patters94825194patter____s
patting103722344patt___ing_
paupering1437274pauper_ing_
peltering122011674pelter_ing_
pestering122315664pester_ing_
petering112516814p_eter_ing_
pettings11349704pett___ings
piercings1453264p__iercings
pittings11349124pitt___ings
plastering1339244plaster_ing_
portering122012304porter_ing_
pothering151911284pother_ing_
potteries11313594potter_i_es
potteringly1762944potter_ingly
pterins9812994p__ter_in_s
quarterings2143724quarter_ings
rattlings10235514ratt__lings
rattooning1143954rattooning_
ravenings13235184ra_ve_nings
sanderlings1343434sanderlings
scattering1398014scatter_ing_
shattering1498284shatter_ing_
smattering1397584smatter_ing_
splattering1454544splatter_ing_
sputtering13106464sputter_ing_
sterlings10308754__sterlings
tattings9408824tatt___ings
tautening1035844taute_ning_
tittering102310314titter_ing_
tottering10229614totter_ing_
turnings9287234___turnings
uttering91613084_utter_ing_
waitering13310714waiter_ing_
wakenings1743044wa_ke_nings
wanderings15215834wander_ings
warnings12358454wa___rnings
watering122316314wa_ter_ing_
waterlines1348954wa_terlines
weatherings1895264weather_ings
whitenings1742614white_nings

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 Filter1786911488190.420425454.8
2DLD Change Limit1488191579.39315843.6
3Display Results1571570.0762065.8
 (SQL Overall)1786911579.88918069.7
 
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.