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

200 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
tannoys105555(None) 
annoys967521_annoys
tannoy958351tannoy_
annoy869712_annoy_
cannons94412882cannons
sannops936692sannops
stannous846442stannous
tangos74216302tango_s
tanners74018392tanners
tannins72813222tannins
tawneys13324772tawneys
alloys94014563_alloys
anions64123033_anions
annals66415923_annals
annas55824883_ann_as
annona648873_annona
annonas738793_annonas
annoyed1185873_annoyed
annoyer1095603_annoyer
annoyers1185033_annoyers
annuls64711733_annuls
anoas57226493_a_noas
anonym1136383_anonym
anonyms1235443_anonyms
anyons94513503_anyons
bancos104713893banco_s
bandogs1138363bandogs
banjoes16317313banjoes
banjos15378893banjo_s
banners94018713banners
bannets94013843bannets
bannock1545043bannock
bannocks1644353bannocks
banns75321233bann__s
barneys12569563barneys
batboys1465833batboys
candors104216763candors
cannas84518403cann_as
cannels93413363cannels
canners93822663canners
cannoli937263cannoli
cannolis1037863cannolis
cannon84514443canno_n
cannot83616773canno_t
canny105817693cann_y_
canoes84725883ca_noes
canons85522063ca_nons
cansos84915383canso_s
cantons95221203cantons
cantors94620753cantors
cantos84826973canto_s
canyons124511593canyons
carboys144711783carboys
carneys124310543carneys
convoys15267023convoys
crannogs1143783crannogs
danios7314603danio_s
enjoys1644603_enjoys
envoys1255143_envoys
fandoms13229473fandoms
fanions103713073fanions
fanners103914653fanners
fannies103415643fannies
fanny114816043fann_y_
fanons96115213fa_nons
fanos85926503fa_no_s
fantods11177623fantods
fantoms12189153fantoms
gannets83811443gannets
ganofs104010293ga_nofs
hansoms12238523hansoms
lanners73618333lanners
mangoes104316133mangoes
mangos94319333mango_s
maniocs113611443maniocs
mannans93611523mannans
mannas85019803mann_as
manners93417833manners
mannose939243mannose
mannoses1039083mannoses
manors84420883ma_nors
manos74933623ma_no_s
minnows1234913minnows
nannies73015203nannies
nanny84813813nann_y_
panners93621273panners
pannes85522853pann_es
pantos85222743panto_s
pawnors12297203pawnors
pennons939713pennons
rancors9811373rancors
randoms102112433randoms
ransoms92410163ransoms
sanious7514103sanious
sannop837373sanno_p
sannups934463sannups
santols73513323santols
santos64421833santo_s
savoys12427893sa_voys
sawneys13274643sawneys
standbys1443203standbys
stannums1043803stannums
stanols739733sta_nols
taboos83815433ta_boos
tabors84517113ta_bors
tacnode1045093tacnode
tacnodes1145003tacnodes
tacos77023553ta_co_s
taenias7311283taenias
tailors73212393tailors
tains54936323tain__s
taints64520533tain_ts
talcous939483talcous
talions7314113talions
tallboys1374623tallboys
tallols73311363tallols
tallows103313743tallows
talons64019443ta_lons
tampons112711563tampons
tandems1037633tandems
tandoor8278563tandoor
tandoors9258053tandoors
tangles83920043tangles
tangly104413913tangly_
tango66921173tango__
tangoed9318833tangoed
tangs65028343ta_n_gs
tangy94519933ta_ngy_
tanists7313653tanists
tankas104613763ta_nkas
tankers113416913tankers
tanks94624733ta_n_ks
tannage8209583tannage
tannages9228963tannages
tannate71813523tannate
tannates81911953tannates
tanned75219953tann_ed
tanner63722283tann_er
tannery10388663tannery
tannest72617853tannest
tannic82811473tann_ic
tannin62613923tann_in
tanning83618253tanning
tannings9268633tannings
tannish101610573tannish
tanrecs934823tanrecs
tans46154823ta_n__s
tansies74521243tansies
tansy84514933ta_nsy_
tanto55724943tanto__
tantras73112093tantras
tanukis1134713tanukis
taos45541003ta__o_s
tarns56433953tarn__s
tarocs84615663ta_rocs
taroks106115283ta_roks
taros55640823ta_ro_s
tarots66422993ta_rots
tarpons92612213tarpons
tatsois748373tatsois
tattoos738643tattoos
taunts65715663taun_ts
tauons63412673ta_uons
tautogs875413tautogs
tawney12338233tawney_
tawnies102812503tawnies
tawny114713653tawn_y_
taxols13328633ta_xols
taxons134211503ta_xons
teapoys1235963teapoys
tendons8311473tendons
tenners74014923tenners
tennies73017973tennies
tennis64015303tenn_is
tenons62916603t_enons
tenors63217753t_enors
tensors72712373tensors
tenuous738483tenuous
tepoys1137543t_epoys
tinners73717313tinners
tinny85317653tinn_y_
tomboys1435713tomboys
tondos75115923tondo_s
tonners73816403tonners
tonnes65320853tonn_es
toys78036343t___oys
trannies8415013trannies
tranny94210863trann_y_
transoms1048933transoms
troys86418613t__roys
tunnels7328723tunnels
tunnies73614263tunnies
tunny86515033tunn_y_
turnons737863turnons
tyrannous1243253tyrannous
vanners103612843vanners
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.390458182.1
2DLD Change Limit1340272007.22018563.3
3Display Results2002000.0603333.3
 (SQL Overall)1786912007.67023297.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.