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

239 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
sannops93669(None) 
sannop837371sannop_
sannups934461sannups
annoys967522_annoys
cannons94412882cannons
saloops93510132saloops
sanious7514102sanious
sannup836562sannup_
santols73513322santols
santos64421832santo_s
snoops84314172s_noops
stannous846442stannous
tannoys1055552tannoys
anions64123033_anions
annals66415923_annals
annas55824883_ann_as
annona648873_annona
annonas738793_annonas
annoy869713_anno_y
annuls64711733_annuls
anoas57226493_a_noas
anyons94513503_anyons
bancos104713893banco_s
bandogs1138363bandogs
banjoes16317313banjoes
banjos15378893banjo_s
banners94018713banners
bannets94013843bannets
bannock1545043bannock
bannocks1644353bannocks
banns75321233bann__s
barhops14288113barhops
candors104216763candors
cannas84518403cann_as
cannels93413363cannels
canners93822663canners
cannoli937263cannoli
cannolis1037863cannolis
cannon84514443canno_n
cannot83616773canno_t
canoes84725883ca_noes
canons85522063ca_nons
canopy1337733ca_nopy
cansos84915383canso_s
cantons95221203cantons
cantors94620753cantors
cantos84826973canto_s
canyons124511593canyons
carhops14329703carhops
catnaps1197033catnaps
catnips1195893catnips
crannogs1143783crannogs
danios7314603danio_s
fandoms13229473fandoms
fanions103713073fanions
fanners103914653fanners
fannies103415643fannies
fanons96115213fa_nons
fanos85926503fa_no_s
fantods11177623fantods
fantoms12189153fantoms
gallops103211653gallops
galops94712623ga_lops
gannets83811443gannets
ganofs104010293ga_nofs
hangups1364823hangups
hansoms12238523hansoms
jalops15329593ja_lops
knops115911813__knops
lanners73618333lanners
laptops1166603laptops
maintops1244403maintops
mangoes104316133mangoes
mangos94319343mango_s
maniocs113611443maniocs
mannans93611523mannans
mannas85019803mann_as
manners93417833manners
mannose939243mannose
mannoses1039083mannoses
manors84420883ma_nors
manos74933623ma_no_s
manrope1138033manrope
manropes1237913manropes
maypops16104453maypops
minnows1234913minnows
nannies73015203nannies
panners93621273panners
pannes85522853pann_es
pantos85222743panto_s
pawnors12297203pawnors
pennons939713pennons
ragtops1035453ragtops
rancors9811373rancors
randoms102112433randoms
ransoms92410163ransoms
sabots8314703sa_bots
sadness8310613sadness
safrols1036863safrols
sagos66123873sa_go_s
sailors73213723sailors
sains55639973sain__s
saints65122423sain_ts
sajous13310583sa_jous
saleps85014903sa_leps
sallows103915553sallows
salmons93713263salmons
salols64017873sa_lols
salons63823693sa_lons
saloons74415323saloons
saloop84212583saloop_
salps74423243sa__lps
salvoes102811313salvoes
salvors103910913salvors
salvos94613383salvo_s
sambos104315193sambo_s
samps96124673sa__mps
sandals82715203sandals
sanders84025943sanders
sandhis1139993sandhis
sandhogs1365483sandhogs
sandlots938293sandlots
sands65228583sa_n_ds
sandsoaps1243683sandsoaps
saneness82313723saneness
sanes55649073sa_n_es
sangars83116253sangars
sangas75222663sa_ngas
sangers84421943sangers
sanghs105312073sa_nghs
sanies63031953sa_nies
sanjaks1834963sanjaks
sannyasi1141903sannyasi
sans45153363sa_n__s
sansars73313913sansars
sanseis73011603sanseis
santims9312603santims
santirs7312963santirs
santo56227283santo__
santol64515243santo_l
santoor737433santoor
santoors837633santoors
santour737373santour
santours837183santours
santurs7310763santurs
sapors84118813sa_pors
saps65346373sa___ps
sarcous9312933sarcous
sargos74318273sargo_s
sarods74918573sa_rods
sarongs84511803sarongs
saros55238063sa_ro_s
sartors7314973sartors
satraps95011643satraps
saunas63915433saun_as
saviors1058993saviors
savors95616103sa_vors
savoys12427893sa_voys
sawlogs1135393sawlogs
sawneys13274643sawneys
scallops12297393scallops
scanners10379703scanners
schnaps1443703schnaps
scoops105414363s_coops
scops95820193s__cops
scroops11288253scroops
segnos73610443segno_s
sendups10115193sendups
senhors103512133senhors
seniors73413623seniors
sennas64214233senn_as
sennets73712583sennets
sennits73811283sennits
senors63620793s_enors
sensors73514643sensors
shallops13288323shallops
shannies113411263shannies
shnapps1463343shnapps
shnaps1148083s_hnaps
shnooks1485583shnooks
shops104222903s__hops
signors83410913signors
sinners74019023sinners
sinuous739063sinuous
sloops85513623s_loops
slops75026013s__lops
snaps74719563s__naps
sneaps84510863s_neaps
snips75818013s__nips
snobs74716153s__nobs
snogs66017493s__nogs
snoods74312453s_noods
snooks104412833s_nooks
snools65715883s_nools
snoop75317173s_noop_
snoopy11449473s_noopy
snoots64216683s_noots
snots55225123s__nots
snows84719893s__nows
sonnets74211993sonnets
sonnies7315223sonnies
sops65244563s___ops
spanners103710773spanners
spinors939423spinors
spinous9310443spinous
standups1143963standups
stanhope1344273stanhope
stanhopes1444463stanhopes
stannums1043803stannums
stanols739733stanols
stenos63915773steno_s
stoops85917893s_toops
stops74827283s__tops
strops86220383s_trops
sunbows1236023sunbows
sundogs947103sundogs
sundrops1145823sundrops
sunnahs10326593sunnahs
sunnas63914563sunn_as
sunns55017353sunn__s
sunups837263s_unups
swoops114910923s_woops
swops105913973s__wops
synanons1144633synanons
syncoms1435943syncoms
syncope1445383syncope
syncopes1545763syncopes
synods1077953s_ynods
sysops1136013s_ysops
tangos74216323tango_s
tanners74018393tanners
tannins72813223tannins
tannoy958363tanno_y
vanners103612843vanners
wallops123410413wallops
wanions104011373wanions
wanness102610683wanness
wantons103713013wantons
winnows1334533winnows

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272396.89019452.4
3Display Results2392390.0932569.9
 (SQL Overall)1786912397.38924183.4
 
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.