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

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

355 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
patterns1043994(None) 
pasterns104112621pasterns
pattens95414921patte_ns
pattern93712051pattern_
patters94825191patter_s
attorns738442_attorns
battens95313262batte_ns
batters94626012batter_s
bitterns10428952bitterns
citterns10318122citterns
fattens105111712fatte_ns
gitterns9326572gitterns
hatters104221522hatter_s
lanterns838302lanterns
lattens75014672latte_ns
matters94421752matter_s
natters73718062natter_s
palters94021682palter_s
pastern94415062pastern_
pasters94531732paster_s
patens84820862pa_te_ns
paters84935832pa_ter_s
patten84418192patte_n_
patter84628262patter__
pattered112714202pattered
patterer103112172patterer
patterers112410122patterers
pattering122314422pattering
patterned1265742patterned
patzers184210572patzer_s
petters93722362petter_s
platters103415282platter_s
posterns102713722posterns
potteens10256792potteens
potters94024342potter_s
putters94219192putter_s
ratteens8256052ratteens
rattens74213402ratte_ns
ratters74422472ratter_s
repatterns1242492repatterns
salterns8388902salterns
slatterns935362slatterns
spatters103914702spatter_s
tatters74520482tatter_s
yatters103914622yatter_s
afters94717073_after_s
alters64924223_alter_s
astern64815813_astern_
asters65631603_aster_s
attains7310983_attains
attars64515313_attar_s
attend7258973_atte_nd
attends8257593_attends
attent62818323_atte_nt
attests7278813_attests
attires72312953_attires
attorn6310793_attorn_
bacterins13410643bacterins
baiters94619303baiter_s
banters94623113banter_s
barters94223033barter_s
basters94930303baster_s
bathers124720363bather_s
batten85217123batte_n_
batter84928873batter__
battered113315053battered
batterer102713213batterer
batterers113110713batterers
batterie10711533batterie
batteries11615113batteries
battering122715143battering
battery124911813batter_y
battlers104110973battler_s
betters94422093better_s
bittern94810683bittern_
bitters94920363bitter_s
blatters104414093blatter_s
butters94521723butter_s
canteens1038573canteens
canters94827733canter_s
carters95327253carter_s
caserns94711223ca_serns
casters94729903caster_s
caterans10313223ca_terans
caters85336503ca_ter_s
catteries11815523catteries
cattery123811603catter_y
caverns124510253ca_verns
chatters134213953chatter_s
cisterns10369573cisterns
citherns13338873citherns
cittern9339143cittern_
clatters103313913clatter_s
cotters94323443cotter_s
cutters94218963cutter_s
darters84017603darter_s
daters74827373da_ter_s
dotters83715973dotter_s
eastern74412533eastern_
easters75125683easter_s
eaters65535953ea_ter_s
externs1438233_externs
falters103916473falter_s
fastens105511753faste_ns
fathers133916503father_s
fatten94314903fatte_n_
fatter94523213fatter__
fetters103517903fetter_s
fitters104517753fitter_s
flattens11357483flatte_ns
flatters113814203flatter_s
gaiters83516543gaiter_s
garters84218233garter_s
gasters85624293gaster_s
gaters74728643ga_ter_s
gathers114315073gather_s
getters84216103getter_s
gittern8337503gittern_
gutters83715513gutter_s
hafters134614333hafter_s
halteres113414593halteres
halters104619803halter_s
haptens124511343hapte_ns
hastens106214813haste_ns
haters94930403ha_ter_s
hatter94724873hatter__
hatteria1137863hatteria
hatterias1258743hatterias
hitters104717593hitter_s
interns73116773_interns
jitters144314473jitter_s
jotters143413803jotter_s
kittens11347583kitte_ns
lantern7310013lantern_
lasters75627693laster_s
lateens74210553la_teens
latens64620213la_te_ns
lathers104321883lather_s
latten65018203latte_n_
latter65027893latter__
latterly1136063latterly
lattes65324203latte__s
lattins74115483latt_ins
lecterns1035943lecterns
letters73819853letter_s
litters73422573litter_s
lotters73921063lotter_s
lutherns1136293lutherns
martens93714953marte_ns
masters94628923master_s
maters85032393ma_ter_s
matter84325343matter__
mattered112412903mattered
mattering122314053mattering
mattery123810713matter_y
mattes85624533matte__s
mattins93316143matt_ins
mattress1036533mattress
mittens9349883mitte_ns
mutters94117143mutter_s
natter64420743natter__
nattered92011623nattered
nattering102212213nattering
netters73618583netter_s
nutters74215433nutter_s
oaters65029793oa_ter_s
otters64021513_otter_s
outturns835913outturns
pacers105124543pa_cer_s
packers153818893packer_s
pactions122613503pactions
padders113312873padder_s
paeans85118263pa__eans
paeons83915523pa__eons
pagers94423253pa_ger_s
painters103013023painter_s
palmers113513623palmer_s
palter84423263palter__
paltered113012483paltered
palterer102411273palterer
palterers11249533palterers
paltering122612893paltering
pampeans1444703pampeans
pamperos14306693pamperos
pampers133615933pamper_s
panders103423733pander_s
pangens103112063pange_ns
paniers94717333panier_s
panners93621273panner_s
pantheons1446513pantheons
panthers13510783panther_s
panzers184012013panzer_s
papers105125323pa_per_s
parers85530743pa_rer_s
parkers133816873parker_s
parsers94118153parser_s
partans94418283part_ans
parterre1036983parterre
parterres1148053parterres
partiers103514243partier_s
partners102711133partner_s
partons94620513part_ons
partyers13277763partyer_s
passers94717753passer_s
pastels95215183paste_ls
paster85734373paster__
pastes85233913paste__s
pasteups1243493pasteups
pastors94119003pastor_s
pastures10311963pastures
patchers153413303patcher_s
paten74827343pa_te_n_
patent84524923pa_te_nt
patents94815203pa_tents
pater74740723pa_ter__
paternal1038333pa_ternal
pates76047893pa_te__s
patient9617073patie_nt
patients1088763patients
patins87528783pa_t_ins
patness92912283patne_ss
patrons93818103pa_trons
patroons102710603patroons
patted94724683patte__d
pattee84323383patte__e
pattened11299393pattened
patterning1346073patterning
patternings1443183patternings
patternless1342283patternless
patties93425143patt_ies
patting103722343patt_ing
pattypans1641753pattypans
patzer173111643patzer__
paupers114311073pauper_s
pausers94113223pauser_s
pavers115021823pa_ver_s
pawers114818783pa_wer_s
pawners124311073pawner_s
payers114621823pa_yer_s
pectens11189203pecte_ns
pelters93720313pelter_s
pesters93827093pester_s
peters86624593p_eter_s
petter83924773petter__
pewters124113353pewter_s
phatter123810203phatter__
piasters102912813piaster_s
pitiers93812653pitier_s
plaiters103512633plaiter_s
planters102915323planter_s
plasters103518133plaster_s
platens94213983plate_ns
platers93924093plater_s
platter93917413platter__
plotters104011553plotter_s
porters93722703porter_s
posteens10309733posteens
postern93615613postern_
posters93928013poster_s
postteens1144373postteens
poteens92910883p_oteens
potheens13266483potheens
potherbs15387123potherbs
pothers123818623pother_s
potteen9319673potteen_
potter83926983potter__
pottered112311663pottered
potterer102310263potterer
potterers11218663potterers
potteries11313593potteries
pottering122612003pottering
pottery123011073potter_y
potzers184010543potzer_s
pouters94221873pouter_s
powters124015663powter_s
praters94921653prater_s
prattlers11195323prattler_s
preteens1038123preteens
preterms1237223preterms
proteans102811543proteans
proteins102114283proteins
psalters10227713psalter_s
pterins9812993p__terins
punters93617043punter_s
puttees93612913putte_es
putter83921443putter__
puttered112611143puttered
putterer10209913putterer
putterers11238363putterers
puttering122611643puttering
puttiers10288013puttier_s
quarterns18285153quarterns
rafters103715633rafter_s
ranters73323643ranter_s
rasters74629023raster_s
raters63936583ra_ter_s
rattans73411953ratt_ans
ratteen7329113ratteen_
ratten64217383ratte_n_
ratter64326313ratter__
rattlers83510293rattler_s
rattons73815323ratt_ons
rattoons8327513rattoons
repattern1143663repattern_
ritters74020623ritter_s
rotters74421393rotter_s
saltern74010653saltern_
salters73622253salter_s
santeras8311063santeras
santeros8311193santeros
sateens73710753sa_teens
sauterne846253sauterne
sauternes947023sauternes
scatters103612753scatter_s
setters73822063setter_s
shatters113313913shatter_s
sitters74221553sitter_s
slattern837093slattern_
smatters104011713smatter_s
spatter94016523spatter__
spattered12187643spattered
spattering13107793spattering
spitters104113383spitter_s
splatters11327543splatter_s
spotters104313383spotter_s
sputters104012873sputter_s
staters73922343stater_s
sterns64616763__sterns
swatters113911793swatter_s
tasters74225643taster_s
taters64932203ta_ter_s
tatter64024573tatter__
tattered92011443tattered
tattering102212323tattering
tattlers8369693tattler_s
tautens7317843taute_ns
taverns10317803ta_verns
terns55226873___terns
tetters74320473tetter_s
titters74219623titter_s
totters74618733totter_s
utters63817123_utter_s
vetters104016323vetter_s
wafters134112813wafter_s
waiters104218623waiter_s
wanters104420093wanter_s
wasters104026593waster_s
waters95030633wa_ter_s
watter93221983watter__
westerns11328963westerns
wetters103817753wetter_s
yatter94116213yatter__
yattered12239533yattered
yattering132410443yattering
zitherns20376133zitherns

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.406440125.6
2DLD Change Limit1461623559.03016186.3
3Display Results3553550.1402535.7
 (SQL Overall)1786913559.57618660.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.