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

258 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
flattery1433829(None) 
clattery13378191clattery
flatter103815961flatter_
flatters113814201flatters
fluttery14376141fluttery
battery124911812_battery
blatter94415652blatter_
blatters104414092blatters
cattery123811602_cattery
chattery16357272chattery
clatter94014972clatter_
clatters103313902clatters
cluttery13346312cluttery
fatter94523212f_atter_
feathery17368072feathery
flackery20295242flackery
flatted114012942flatte_d
flatten10429652flatte_n
flattens11357482flattens
flattered13188622flattered
flatterer12187672flatterer
flattest1138712flattest
flitter103413902flitter_
flitters114312172flitters
flutter104012092flutter_
flutters114010812flutters
glittery12375612glittery
lathery133911122_lathery
latter65027892_latter_
latterly1136062_latterly
littery103710482_littery
lottery10389822_lottery
mattery123810712_mattery
plastery13279702plastery
platter93917412platter_
platters103415282platters
slattern837092slattern
aflutter1163813aflutter_
artery9911453__artery
batter84928873_batter_
batters94626013_batters
bladdery15344583bladdery
blaster94017303blaster_
blasters104116143blasters
blather125314203blather_
blathers134713793blathers
blatted104812713blatte_d
blattered12198563blattered
blistery13418713blistery
blotter94612853blotter_
blotters104110983blotters
blustery13368003blustery
buttery124311193_buttery
cautery12349573_cautery
chatter124416643chatter_
chatters134213933chatters
clattered12178403clattered
clatterer11186983clatterer
clustery13317103clustery
clutter94211653clutter_
clutters103210343clutters
eatery95316353_ea_tery
elater64724203ela_ter_
elaters74420183ela_ters
factory15108343f_actory
faery116015483f_a__ery
fakery16509263f_a_kery
falter94519053f_alter_
falters103916473f_alters
faster94625773f_aster_
father125116713f_ather_
fatherly1745073f_atherly
fathers133916503f_athers
fatted105419843f_atte_d
fatten94314903f_atte_n
fattens105111713f_attens
fattest102913063f_attest
fattier103513463f_attier_
fattily13379463f_attily
fatty115117413f_att__y
feaster10812983feaster_
feasters11511563feasters
feater95224053fea_ter_
feather133613503feather_
feathers143513243feathers
fetter94120383f_etter_
fetters103517903f_etters
fitter94120033f_itter_
fitters104517743f_itters
flagger12469343flagger_
flaggers13328073flaggers
flaker134916173fla_ker_
flakers143613273fla_kers
flakey164410513fla_ke_y
flakier143910203flakier_
flamer114919123fla_mer_
flamers124616363fla_mers
flamier123112143flamier_
flanger113412623flanger_
flangers123311373flangers
flanker143911293flanker_
flankers15349303flankers
flapper14359203flapper_
flappers15388383flappers
flasher133914063flasher_
flashers143912653flashers
flatbed13397983flatbe_d
flatbeds14364543flatbeds
flatcar1274613flatcar_
flatcars1344623flatcars
flatfeet1446213flatfeet
flathead1535803flathead
flatlet10312253flatle_t
flatlets1147373flatlets
flatly123110213fla_t_ly
flatness1138153flatness
flattened13185303flattened
flattener12175173flattener
flatteners13164153flatteners
flatterers13175913flatterers
flatteries1347413flatteries
flattering1498743flattering
flatting123511253flatting
flattish1455263flattish
flattop1244403flatt_op
flattops1344553flattops
flatware1444883flatware
flatwork1845393flatwork
flatworm1645173flatworm
flaunter1135013flaunter_
flaunters1234503flaunters
flavory1644743fla_vory
flavoury1743063flavoury
flawier13378733flawier_
flaxier17337983flaxier_
flayer124713563fla_yer_
flayers133912033fla_yers
fleeter103210363fleeter_
flickery20365103flickery
flirter10318673flirter_
flirters11337933flirters
flitted114011643flitte_d
flittered13196253flittered
floater104413353floater_
floaters112711503floaters
floatier1136983floatier_
flouter104311343flouter_
flouters11419263flouters
flowery16327783fl_owery
flummery1833053flummery
fluster103913063fluster_
flusters113811493flusters
fluter95316863fl_uter_
fluters103713673fl_uters
flutey125212523fl_ute_y
flutier103011553flutier_
fluttered13185943fluttered
flutterer12185263flutterer
flytier13356503flytier_
flytiers14254483flytiers
frater94520593fra_ter_
fraters103517203fra_ters
fretter103412753fretter_
fretters113410303fretters
fritter103912773fritter_
fritters113810783fritters
glaziery21413693glaziery
glitter84211803glitter_
glitters93710543glitters
guttery11427753_guttery
hatter94724873_hatter_
hatters104221523_hatters
heathery17349083heathery
jittery17346443_jittery
lactary1237843_lactary
lantern7310013_lantern
laster64830633_laster_
lasters75627693_lasters
lately93413843_la_tely
later54843923_la_ter_
lather95124353_lather_
lathers104321883_lathers
latte55426303_latte__
latten65018203_latte_n
lattens75014673_lattens
lattes65324203_latte_s
leathery14438973leathery
letter63722583_letter_
letters73819853_letters
litter64324853_litter_
litters73422563_litters
lotter64025603_lotter_
lotters73921063_lotters
mastery124214323_mastery
matter84325343_matter_
matters94421753_matters
natter64420743_natter_
natters73718063_natters
patter84628263_patter_
pattern93712053_pattern
patters94825193_patters
phatter123810203phatter_
plaiter93615393plaiter_
plaiters103512633plaiters
planter94017803planter_
planters102915323planters
plaster93318693plaster_
plasters103518133plasters
plater84427693pla_ter_
platers93924083pla_ters
platier93716293platier_
platted103614263platte_d
plotter94113663plotter_
plotters104011553plotters
pottery123011073_pottery
psaltery13224733psaltery
ratter64326313_ratter_
ratters74422473_ratters
scatter93815173scatter_
scatters103612753scatters
shatter103615693shatter_
shatters113313903shatters
skittery15315103skittery
slabbery15375773slabbery
slater64429183sla_ter_
slaters73123723sla_ters
slatey95417063sla_te_y
slather103816063slather_
slathers113914773slathers
slatier74016813slatier_
slatted84015183slatte_d
slatternly1342233slatternly
slatterns935363slatterns
slavery13407893sla_very
slithery14356703slithery
slitter73615873slitter_
slitters84014133slitters
slotter73314443slotter_
slotters84012393slotters
smatter93613333smatter_
smatters104011713smatters
spatter94016523spatter_
spatters103914703spatters
splatter10348883splatter_
splatters11327543splatters
spluttery14293623spluttery
sputtery13366473sputtery
swatter104113323swatter_
swatters113911793swatters
tatter64024573_tatter_
tatters74520483_tatters
tottery10388483_tottery
twittery14303893twittery
wastery134610993_wastery
watery123914493_wa_tery
watter93221983_watter_
yatter94116213_yatter_
yatters103914623_yatters

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461622588.34317519.1
3Display Results2582580.1102345.5
 (SQL Overall)1786912588.62320722.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.