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

203 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
tectites103999(None) 
tectite9310581tectite_
tektites1236611tektites
pectates122213952pectates
pectines121914682pectines
pectizes21229792pectizes
petites93820202pe_tites
recites93524582rec_ites
smectites1344622smectites
steatites939842steatites
teatimes1039442teatimes
techies12513602techi_es
tectrices1346252tectrices
tektite1136882tektite_
tergites9310542tergites
termites10313692termites
testates83615452testates
textiles1536832textiles
acetates102013063acetates
actives12311523_actives
apatites10311293apatites
ascites9312603asc_ites
becrimes1467073becrimes
bedtimes1336593bedtimes
betides104915263be_tides
betimes115114413be_times
betises94816123be_tises
biotites10310083biotites
cecities12312043cecities
centiles103615813centiles
centimes124012613centimes
cerites94823433ce_rites
cites74435593__c_ites
dacites101114593dac_ites
deceits102810883deceit_s
deceives1437903deceives
decides114217653dec_ides
deciles104417723dec_iles
declines113315803declines
decries103319803decri_es
deities82621923deiti_es
dentines93418403dentines
despites11410313despites
destines93619663destines
detectives1645783detectives
dictates11311383dictates
ecartes94212563_ecartes
ectases92911673_ectases
ectypes1434803_ectypes
ejectives2145443ejectives
electives1448933electives
elites66027123_e_lites
endites83717063_endites
entices91616333_entices
entires71517783_entires
entities8617413_entities
entitles8710663_entitles
equites162212493_equites
estates74520183_estates
eucrites1049483eucrites
evites94916473_e_vites
excites16310633_excites
felsites1138073felsites
ferrites112312833ferrites
gentiles93713523gentiles
gestates93213733gestates
hectares1338853hectares
helictites1544653helictites
hematites141510793hematites
hessites1138613hessites
incites93218483inc_ites
jetties143613123jetti_es
kernites1269113kernites
lactates10311223lactates
lectins92515003lecti_ns
lections102413843lections
lectures101310153lectures
lefties10312073lefti_es
lenites7818443le_nites
leucites1037333leucites
lucites9311863luc_ites
metates92720013me_tates
neckties1445903neckti_es
nictates1039593nictates
pectases122411193pectases
pectate112214693pectate_
pectins112315233pecti_ns
pectize20259913pectize_
pectized22257593pectized
pelites93821993pe_lites
penlites10312273penlites
peptides132610263peptides
peptizes21269853peptizes
perlites10316363perlites
petite84320653pe_tite_
pettitoes1144183pettitoes
picrites121811083picrites
ratites74920683_ratites
receives1339743receives
recipes113314463rec_ipes
recite83625113rec_ite_
recited104319103rec_ited
reciter94117263rec_iter
reciters102613113rec_iters
recits83621353rec_it_s
reclines103718543reclines
recrates102420373recrates
rectifies14310813rectifies
rectitudes1344793rectitudes
rectrices1338873rectrices
reptiles103913063reptiles
requites171511763requites
resites74027793re_sites
respites10513243respites
restates83423433restates
reties65436193re_ti_es
retiles74426993re_tiles
retimes95020173re_times
retines75134673re_tines
retires74726213re_tires
retitles83612593re_titles
reunites8312473reunites
rewrites11311063rewrites
secretes10410473secretes
sectile9311973sectile_
sections102714703sections
septimes1238303septimes
sestines82717243sestines
sextiles1537643sextiles
smectite1245773smectite_
spectates13228813spectates
steatite8310583steatite_
stellites938123stellites
sternites9310073sternites
tachistes1466043tachistes
taconites1148473taconites
tacrines10310563tacrines
tactics1149323tacti_cs
tactile9310613tactile_
tactions102912423tactions
tatties74120343tatti_es
taxites1449673t_axites
teatime9310083teatime_
techie11511723techi_e_
techier1269243techi_er
techiest1359833techi_est
tectums11306423tect_ums
teddies92711283teddi_es
teethes103611653teet_hes
tekkies1035943tekki_es
tektitic1444133tektitic
tellies73820503telli_es
tennies73017973tenni_es
tennises82810133tennises
tenorites9311093tenorites
tensities9311333tensities
tentages91011043tentages
tentie62521183tenti_e_
tentier73815923tenti_er
tentiest82115613tenti_est
tenuities949763tenuities
teosintes944553teosintes
tephrites1446313tephrites
tergite8311003tergite_
termite9313893termite_
termtimes1354803termtimes
terries73425633terri_es
terrines82117553terrines
territs72714503territ_s
tertials8510073tertials
tertians839103tertians
testate73916233testate_
testees74215913test_ees
testes65125823te__stes
testicles1146773testicles
testier74015643testi_er
testiest82715223testi_est
testifies12139263testifies
testiness9209753testiness
testis64916713testi__s
tetter64322453te_t_ter
tetters74320473te_t_ters
textile1437223textile_
textures1597523textures
thermites1438043thermites
thorites11312393thorites
tillites8312833tillites
titties73617363titti_es
tomtits937243tomtit_s
tontines82114733tontines
tractates1159763tractates
treaties8316983treati_es
treatises9310373treatises
trichites1448883trichites
turgites937783turgites
tutties73216473tutti_es
twenties1137503twenti_es
velites103417303ve_lites
verites103822263ve_rites
vertices13612283vertices
vestiges1238243vestiges
websites1335183websites
zeolites1738383zeolites

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622036.84321359.3
3Display Results2032030.0762671.1
 (SQL Overall)1786912037.34224338.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.