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

184 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
teacup103625(None) 
teacups1133961teacups
teach105221122teac_h
abacus10349763abacus
backup1646613_backup
beach124623893beac_h
beachy164011253beachy
beacon10511373beacon
beau66137273bea_u_
beaucoup1442193beaucoup
beaus75127113bea_us
beaut75135213bea_ut
beaux146513213bea_ux
becap114315053be_cap
breakup1543463breakup
caecum1238183caecum
cecum11611843ce_cum
cercus105013153cercus
cleanup1144083cleanup
crackup1743563crackup
cup76738243___cup
deacon9510423deacon
deathcup1641603deathcup
decamp1338453decamp
each95530583_eac_h
eau37450943_ea_u_
eaux116618423_ea_ux
ecu56828233_e_cu_
ecus65421463_e_cus
eggcup1241833eggcup
eyecup1344493eyecup
faceup1334893_faceup
fescue1137493fescue
gelcap1136213gelcap
getup83410263ge_tup
heap96432893hea__p
hiccup1554393hiccup
jaup135316423_ja_up
ketchup1842783ketchup
layup1037723_layup
leach105422523leac_h
leachy14419733leachy
league758743league
leap66032683lea__p
letup73712163le_tup
meatus85112923meatus
neap66927013nea__p
oilcup1044253oilcup
peace95026083peac_e
peaced115818913peaced
peaces106324083peaces
peach125422493peac_h
peachy164510843peachy
peanut8318183peanut
reach105123883reac_h
react74634333reac_t
reacts83616603reacts
reap65934743rea__p
recap95718023re_cap
recoup10810373recoup
recur74116843re_cur
recut74729243re_cut
redcap1158493redcap
rescue8313003rescue
scaup95515993sca_up
scup84822383__scup
sendup9106343sendup
setup73915823se_tup
stackup1533743stackup
tabu66328493t_abu_
tabun75914373t_abun
tabus74820923t_abus
tace65342513t_ac_e
taces76237803t_aces
tacet75840023t_acet
tach96132753t_ac_h
tache106222373t_ache
tachs105820933t_achs
tacit76333673t_acit
tack106536293t_ac_k
tacks115430133t_acks
tacky145617443t_acky
taco67031353t_ac_o
tacos77023553t_acos
tact67349033t_ac_t
tacts76524123t_acts
takeup1234583takeup
talcum1036953talcum
taluk94812873t_aluk
talus55423263t_alus
tamp86133013t_a_mp
tap57663883t_a__p
tarp66936423t_a_rp
tau36856903t_a_u_
taupe7314173t_a_upe
taus46342733t_a_us
taut47048963t_a_ut
taxus125512483t_axus
tea37353323tea___
teabox1536013teabox
teacake1335453teacake
teacart91113193teacart
teacher123714833teacher
teaches122718353teaches
teacupful1651223teacupful
teak85930843tea__k
teaks94222903tea_ks
teal45546503tea__l
teals56234133tea_ls
team66238653tea__m
teamed95418593teamed
teams75726513tea_ms
teapot8416763teapot
teapoy1138113teapoy
tear45242883tea__r
teared75722153teared
tearer64822903tearer
tearful1046033tearful
tears55436463tea_rs
teary85124053tea_ry
teas45851493tea__s
tease55428713tea_se
teased74721153teased
teasel63914983teasel
teaser65421523teaser
teases65426273teases
teashop1246083teashop
teat45963633tea__t
teated74924023teated
teats55636813tea_ts
teazel15368543teazel
teazle15329553teazle
tech95925443te_c_h
techs106915833te_chs
techy135612013te_chy
tecta74215523te_cta
tectum10328603tectum
tedium9269873tedium
tegua6109563te_gua
telco7511873telc_o
telcos8710683telcos
telium82611393telium
temp85323333te__mp
tenace82715693tenac_e
tenaces92814513tenaces
tenacula1044493tenacula
tench105620003tenc_h
tendu67216003tendu_
tendus75111183tendus
tenour62610733tenour
terce75721843terc_e
tercel83612993tercel
terces83921413terces
tercet83624913tercet
tergum937933tergum
tetanus737933tetanus
tetchy1436003tetchy
teuch105214853teuc_h
thack144915173thac_k
thacks154311923thacks
tittup834203tittup
toecap1037323toecap
tossup875293tossup
touchup1443833touchup
trace75829613trac_e
traced94821583traced
tracer84820233tracer
traces85329933traces
track114823013trac_k
tracks124818843tracks
tract75635713trac_t
tracts85019073tracts
tragus749233tragus
tramp96319773tra_mp
trap67532803tra__p
treacle939973treacle
treacly1237093treacly
tricep103911073tricep
tuneup835203tuneup
tup56037543t___up
turnup835093turnup
vacua10510463_vacua
whaup13458883wha_up
yaup96618483_ya_up

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161846.40617595.4
3Display Results1841840.0464000.0
 (SQL Overall)1786911846.84226116.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.