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

129 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
trisects103598(None) 
trisect939731trisect_
bisects1137132_bisects
prosects1239472prosects
resects94115592_resects
trajects1744532trajects
transects1157822transects
tridents938582tridents
trifecta1343572trifecta
trifectas1443662trifectas
trijets14308262trije_ts
trisected1244912trisected
trisector1144322trisector
trisectors1244462trisectors
trisemes1036642trisemes
trivets103911582trive_ts
arises65233803arise__s
bisect10312873_bisect_
brises84927613brise__s
briskets14346563briskets
crises84529433crise__s
crusets93811043cruse_ts
directs102710263_directs
disjects18275923_disjects
dissects11279243dissects
erects84116183er__ects
exsects1655573_exsects
frisees104411693frise_es
frises94124273frise__s
frisette1195483frisette
frisettes1295363frisettes
friseurs1133303friseurs
friskets15326263friskets
griseous945613griseous
grisette994653grisette
grisettes1094713grisettes
grists74716483gris__ts
grivets11357973grive_ts
insects93710843_insects
irises64221173irise__s
krises105016083krise__s
misacts1139353_misacts
miseats92815793_miseats
orients7311583ori_ents
prefects1598133prefects
prelects1299723prelects
presents103315643presents
presets94216423prese_ts
priests93810863pri_ests
priseres10310823priseres
prises84133173prise__s
privets122910053prive_ts
projects1936413projects
prosect11313393prosect_
prospects1545103prospects
protects1239743protects
refects124012743_refects
rejects163910693_rejects
reseats74319583_reseats
resect84424703_resect_
resents74221223_resents
resets65427613_rese_ts
respects1247703_respects
risers64624783_rise_rs
rises55244043_rise__s
rivets94417113_rive_ts
rosets65819953_rose_ts
sects75622893___sects
subsects12267903subsects
tassets75012773tasse_ts
tincts84510803t_i_ncts
toilets74112913toile_ts
tracts85019073tr__acts
traject1637043traject_
transacts1157363transacts
transect10410053transect_
transepts1146383transepts
transfects1545723transfects
treats64821693tr__eats
trets55928023tr__e_ts
trevets10499973treve_ts
triacs83913223tri_ac_s
tribes85119023tribe__s
triceps11267343trice_ps
trices84826333tri__ces
tricks125319013tri__cks
tricots9311563tri_cots
trident8314193trident_
trienes74118413tri_enes
triens65417543tri_e_ns
trientes82812133tri_entes
triers64321523tri_e_rs
tries55742813tri_e__s
trijet133916553trije_t_
trikes105419493trike__s
trimers94615143trime_rs
trines64132563trine__s
trinkets1237143trinkets
triolets83410143triolets
trioses75015653triose__s
tripacks1664893tripacks
tripes85324873tripe__s
triplets103510263triplets
trippets12357423trippets
triremes1035523triremes
triscele1045433triscele
trisceles1145293trisceles
trisecting1345503trisecting
trisection1245983trisection
trisections1345643trisections
triseme936543trise_me
trisemic1245193trisemic
trishaws1444003trishaws
triskeles1344273triskeles
trismus935563tris_mus
trisomes1039833trisomes
tristate8311033tristate
triste63818643tris__te
tristezas1842753tristezas
tristichs1444613tristichs
tritest7315273tritest_
trivet93721883trive_t_
trusts64714433trus__ts
trysts9448793trys__ts
twinsets1133663twinse_ts
twists9549753twis__ts
vivisects1742083vivisects
wisents10249063_wisents
wrists95415643wris__ts

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.453394461.4
2DLD Change Limit1461621296.98320931.1
3Display Results1291290.0632047.6
 (SQL Overall)1786911297.49923828.6
 
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.