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

153 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
teabox153601(None) 
gearbox1742952gearbox
pegbox1844012pegbox
taboo73418092t_aboo
tabor75518392t_abor
teabowl1244142teabowl
teaboxes1745062teaboxes
teapot8416762teapot
teapoy1138112teapoy
abo59045963__abo_
abos67734413__abos
attaboy1264303attaboy
baboo94319503_baboo
beacon10511373beacon
beano75421553beano_
beanos85516513beanos
beaux146513213bea_ux
bebop11410793be_bop
belabor1136293belabor
box1210142343___box
breadbox2042433breadbox
cabob114616813_cabob
coalbox1844113coalbox
deacon9510423deacon
detox13310953de_tox
eaux116618423_ea_ux
ebon66821103_e_bon
elbow10117703_elbow
embow1297563_embow
etalon648973etalon
feedbox2052663feedbox
hatbox1835133hatbox
hellbox1944983hellbox
hotbox1835693hotbox
icebox1753083icebox
jabot14321513_jabot
jerboa1535633jerboa
kabob134113933_kabob
kebob135110923ke_bob
labor75117313_labor
lesbo739253lesbo_
lesbos837403lesbos
meadow1237403meadow
nabob93913743_nabob
outbox1537463outbox
reason62616333reason
reavow1235723reavow
rebop9313283re_bop
redox134714233re_dox
sabot7931773_sabot
seabag938473seabag
seabed95017693seabed
seaboot9512333seaboot
seadog838743seadog
season62714903season
skybox2242293skybox
soapbox1843123soapbox
sweatbox2041543sweatbox
tab57460323t_ab__
tabby125213893t_abby
taber73825823t_aber
tabes76033923t_abes
tabid84418263t_abid
tabla73318363t_abla
table75429603t_able
taboos83815423t_aboos
tabors84517113t_abors
tabour84011323t_abour
tabs66842983t_ab_s
tabu66328493t_ab_u
tabun75914373t_abun
tabus74820923t_abus
taco67031353t_aco_
tacos77023553t_acos
talon55824113t_alon
tao38358953t_a_o_
taos45541003t_a_os
taro46846913t_aro_
taroc75721643t_aroc
tarok97921073t_arok
taros55640823t_aros
tarot55943933t_arot
tauon54816583t_auon
tax109449153t_a__x
taxol124011363t_axol
taxon124414663t_axon
tea37353323tea___
teaboard1146293teaboard
teabowls1343463teabowls
teach105221123tea_ch
teacup1036253teacup
teak85930843tea__k
teaks94222903tea_ks
teal45546503tea__l
teals56234133tea_ls
team66238653tea__m
teamed95418593teamed
teams75726513tea_ms
teapots939053teapots
teapoys1235963teapoys
tear45242883tea__r
teared75722153teared
tearer64822903tearer
tearoom939063tearoom
tears55436463tea_rs
teary85124053tea_ry
teas45851493tea__s
tease55428713tea_se
teased74721153teased
teasel63914983teasel
teaser65421523teaser
teases65426273teases
teashop1246083teashop
teat45963633tea__t
teated74924023teated
teats55636813tea_ts
teazel15368543teazel
teazle15329553teazle
teflon937453teflon
telamon936523telamon
telco7511873telco_
telcos8710683telcos
telex125214823te_lex
teloi54217383te_loi
telos55424523te_los
telson6310293telson
temblor1144093temblor
tempo95214973tempo_
tempos103812293tempos
tenable93214493tenable
tenably122210453tenably
tendon7312033tendon
tenon53320513te_non
tenor53620253te_nor
tensor63812673tensor
tepoy10312163te_poy
terbia8311153terbia
terbic10410963terbic
termor84412513termor
terror63811723terror
teston6313303teston
tomboy1358213tomboy
toolbox1653633toolbox
treason748763treason
turbo71015043turbo_
turbos8910783turbos
turbot8914263turbot
unbox1438753_unbox
weakon13357623weakon
weapon11288113weapon
weason93210823weason
xerox1138623xe_rox
zealot15313473zealot

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 Filter1786911127160.250714764.0
2DLD Change Limit1127161536.76616659.2
3Display Results1531530.0762013.2
 (SQL Overall)1786911537.09225196.1
 
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.