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 “teacart” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
teacart9111319(None) 
teacarts10116071teacarts
teacake1335452teacake
teaware1048142teaware
tipcart1148832tipcart
acari75020283__acari
apart74330673__apart
bearcat11611913bearca_t
cart66570343___cart
decant93524223de_cant
decare93919153de_care
depart94720563de_part
descant104315593descant
dogcart1148043dogcart
ecarte84313503_e_carte
escar74011993_escar_
escarp10449003_escarp
escars83913133_escars
escort84616483_escort
heart85440743he__art
hepcat13611823hepca_t
keycard1743663keycard
oxcart1539523_oxcart
peacoat11412913peacoat
peart76440753pe__art
peasant9314923peasant
peccant13311733peccant
peccary1636283peccary
placard1236783placard
react74634333reac__t
reactant10311433reactant
readapt1039743readapt
recant83228683re_cant
recast83422773re_cast
rechart12314343rechart
restart7320033restart
scart76139773__scart
seacoast1047783seacoast
seacraft1346523seacraft
seagirt8310153seagirt
sealant73118303sealant
seamark1336723seamark
seaport9315603seaport
seawant103613413seawant
seaward1148183seaward
seaware1049633seaware
secant84023293se_cant
tabard9313333t_abard
tabaret92717313t_abaret
tacet75840023t_ac_et
tacit76333673t_ac_it
tacket124627493t_acket
tact67349033t_ac__t
talar56225383t_alar_
talars66021683t_alars
tamari8313413t_amari
tart47566183t___art
tatar56122063t_atar_
tatars64619793t_atars
teaboard1146293teaboard
teacakes1435883teacakes
teach105221123teac__h
teacher123714833teacher
teachers133212393teachers
teaches122718353teaches
teacup1036253teac_up
teacups1133963teacups
teapot8416763tea_pot
tear45242883te__ar_
tearer64822903tearer_
tearers75218233tearers
tears55436463te__ars
teary85124053te__ary
teaser65421523teaser_
teasers75317243teasers
teat45963633te__a_t
teawares1148083teawares
telecast1048303telecast
tenant6322473te_nant
terawatt1147373terawatt
tercet83624913terc_et
ternary1038343ternary
theocrat1346353theocrat
thrawart1445163thrawart
thwart12311683t_hwart
tipcarts1244573tipcarts
tipcat10312653tipca_t
tomcat101013453tomca_t
tracer84820233tracer_
tracers94917843tracers
tracery12399793tracery
tract75635713trac__t
tramcar1135593tramcar_
tramcars1245233tramcars
tripart9311433tripart
trocar848773trocar_
trocars959043trocars
tuatara745513tuatara
vacant11415133_vacant
webcast1445553webcast

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 Limit1340271006.60620288.7
3Display Results1001000.0333030.3
 (SQL Overall)1786911007.04525364.2
 
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.