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

171 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
slatterns93536(None) 
slattern837091slattern_
blatters104414092blatter_s
clatters103313912clatter_s
flattens11357482flatte_ns
flatters113814202flatter_s
lanterns838302_lanterns
lattens75014672_latte_ns
patterns10439942_patterns
platters103415282platter_s
salterns8388902s_alterns
scatters103612752scatter_s
shatters113313912shatter_s
slaters73123732sla_ter_s
slathers113914782slather_s
slatternly1342232slatternly
slitters84014132slitter_s
slotters84012402slotter_s
smatters104011712smatter_s
spatters103914702spatter_s
splatters11327542splatter_s
swatters113911792swatter_s
attorns738443__attorns
battens95313263_batte_ns
batters94626013_batter_s
bitterns10428953_bitterns
blasters104116143blaster_s
blathers134713793blather_s
blatter94415653blatter__
blattered12198573blattered
blattering13108713blattering
blotters104110983blotter_s
chatters134213953chatter_s
citterns10318123_citterns
clatter94014973clatter__
clattered12178413clattered
clatterer11186993clatterer
clatterers12155423clatterers
clattering13109233clattering
clattery13378193clatter_y
clutters103210353clutter_s
elaterins9410033ela_terins
elaters74420193ela_ter_s
fattens105111713_fatte_ns
flatten10429653flatte_n_
flatter103815963flatter__
flattered13188633flattered
flatterer12187683flatterer
flatterers13175913flatterers
flatteries1347423flatteries
flattering1498743flattering
flattery14338293flatter_y
flitters114312173flitter_s
flutters114010823flutter_s
gitterns9326573_gitterns
glitters93710543glitter_s
hatters104221523_hatter_s
klaverns1532243kla_verns
lantern7310013_lantern_
lasters75627693_laster_s
lateens74210553_la_teens
latens64620213_la_te_ns
lathers104321883_lather_s
latten65018203_latte_n_
latter65027893_latter__
latterly1136063_latterly
lattes65324203_latte__s
lattins74115483_latt_ins
lecterns1035943_lecterns
letters73819853_letter_s
litters73422573_litter_s
lotters73921063_lotter_s
lutherns1136293_lutherns
matters94421753_matter_s
natters73718063_natter_s
pasterns104112623_pasterns
pattens95414923_patte_ns
pattern93712053_pattern_
patters94825193_patter_s
plaiters103512633plaiter_s
planters102915323planter_s
plasters103518133plaster_s
platens94213983pla_te_ns
platers93924093pla_ter_s
platter93917413platter__
plotters104011553plotter_s
quarterns18285153quarterns
ratteens8256053_ratteens
rattens74213403_ratte_ns
ratters74422473_ratter_s
repatterns1242493repatterns
saltern74010653s_altern_
salters73622253s_alter_s
saltiers83411953saltier_s
saluters8319863saluter_s
santeras8311063s_anteras
santeros8311193s_anteros
sateens73710753s_a_teens
sauterne846253s_auterne
sauternes947023s_auternes
scatter93815173scatter__
scattered12197353scattered
scatterer11186293scatterer
scatterers12205043scatterers
scatterguns1451273scatterguns
scattering1398013scattering
scatterings14103973scatterings
scutters103311023scutter_s
seaters74028943sea_ter_s
setters73822063s_etter_s
shatter103615703shatter__
shattered13178203shattered
shatterer12177203shatterer
shatterers13185723shatterers
shattering1498283shattering
shutters113611353shutter_s
sitters74221553s_itter_s
skaters113512963ska_ter_s
skitters12349553skitter_s
slabbers123610123slabber_s
slackens14367713slacke_ns
slackers143812743slacker_s
slakers114115753sla_ker_s
slammers123511223slammer_s
slanders94014013slander_s
slappers123710953slapper_s
slashers113313613slasher_s
slater64429183sla_ter__
slates64934063sla_te__s
slather103816083slather__
slathered13148553slathered
slathering14108283slathering
slatier74016813slatier__
slatted84015183slatte__d
slatting94014233slatt_ing
slattings10346073slattings
slavers103716503sla_ver_s
slayers104513323sla_yer_s
slithers114212953slither_s
slitter73615873slitter__
slotter73314453slotter__
smartens10286663smarte_ns
smatter93613333smatter__
smattered12186783smattered
smatterer11185813smatterer
smatterers12174873smatterers
smattering1397583smattering
smatterings14103843smatterings
southerns12347213southerns
spatter94016523spatter__
spattered12187643spattered
spattering13107793spattering
spitters104113383spitter_s
splatter10348883splatter__
splattered13163943splattered
splattering1454543splattering
splitters11307323splitter_s
splutters11286273splutter_s
spotters104313383spotter_s
sputters104012873sputter_s
squatters1834943squatter_s
starters83714773starter_s
staters73922343sta_ter_s
sterns64616763s___terns
stutters83210473stutter_s
subalterns1242223subalterns
swathers144512083swather_s
swatter104113323swatter__
swotters11448483swotter_s
tatters74520483_tatter_s
yatters103914623_yatter_s

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411716.53322752.3
3Display Results1711710.0632714.3
 (SQL Overall)1786911717.01625469.1
 
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.