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

170 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
trisect93973(None) 
trisects1035981trisects
bisect10312872_bisect
prosect11313392prosect
resect84424702_resect
traject1637042traject
transect10410052transect
trident8314192trident
trifecta1343572trifecta
trijet133916552trije_t
trisected1244912trisected
trisector1144322trisector
triseme936542triseme
tritest7315272tritest
trivet93721882trive_t
aridest8316143aridest
arise56436433arise__
arisen65316793arise_n
arises65233803arise_s
bisects1137133_bisects
brisant9312683brisant
brises84927613brise_s
briskest14337803briskest
brisket134413403brisket
crises84529433crise_s
crisic103611843crisic_
crispest12177373crispest
cruset84425093cruse_t
direct93817333_direct
disject17268673_disject
dissect103614133dissect
driest74722753dri_est
erect74129333er__ect
exsect1558503_exsect
frise85322453frise__
frisee94217993frise_e
frisees104411693frisees
frises94124273frise_s
frisette1195483frisette
friseur1033673friseur
frisket143811773frisket
grisette994653grisette
grist65529873gris__t
grivet103517823grive_t
insect83916583_insect
irised73913153irise_d
irises64221173irise_s
krises105016083krise_s
misact10316693_misact
miseat82925713_miseat
orient6322533ori_ent
prefect141011073prefect
prelect111013833prelect
present94022733present
preset84430983prese_t
priest84125423pri_est
prise74632613prise__
prised94322203prise_d
prisere9310943prisere
prises84133173prise_s
privet113821343prive_t
project1838453project
prosects1239473prosects
prospect1447893prospect
protect11313633protect
refect114319333_refect
reject154116283_reject
reseat64131493_reseat
resects94115593_resects
resent63833623_resent
reset55051863_rese_t
respect11412033_respect
rident7520193_rident
rifest93114583_rifest
ripest84317943_ripest
rise45945243_rise__
risen54621883_rise_n
riser55431053_rise_r
risers64624783_risers
rises55244043_rise_s
rivet85636363_rive_t
roset55945243_rose_t
sect67443623___sect
strict84821043stri__ct
strident9310173strident
subsect112611843subsect
tasset65925313tasse_t
tensest72713313tensest
tersest71713993tersest
tinct76126233t_i_nct
toilet66228093toile_t
tract75635713tr__act
trajects1744533trajects
transact1049823transact
transects1157823transects
transept1048633transept
transfect1446733transfect
treat56240353tr__eat
tret46653533tr__e_t
trevet94818913treve_t
triac74116373tri_ac_
triacs83913223tri_acs
tribe74420273tribe__
tribes85119023tribe_s
trice75127493tri__ce
triced95518673trice_d
tricep103911073trice_p
triceps11267343triceps
trices84826333trice_s
trick115420693tri__ck
tricot8317753tri_cot
tridents938583tridents
tried65026913tri_e_d
triene64316383tri_ene
triens65417543tri_ens
trier54328533tri_e_r
triers64321523tri_ers
tries55742813tri_e_s
trifectas1443663trifectas
triggest1036923triggest
trijets14308263trijets
trike95320163trike__
trikes105419493trike_s
trimer85717153trime_r
trimers94615143trimers
trimmest12227023trimmest
trine54734603trine__
trined74920713trine_d
trines64132563trine_s
trinket11314813trinket
triolet73219523triolet
triose64715383triose__
trioses75015653triose_s
tripack1565673tripack
tripart9311433tripart
tripe75425383tripe__
tripes85324873tripe_s
triplet94319213triplet
trippet113714113trippet
trireme935263trireme
triscele1045433triscele
trisecting1345503trisecting
trisection1245983trisection
trisectors1244463trisectors
trisemes1036643trisemes
trisemic1245193trisemic
trishaw1344753trishaw
triskele1244573triskele
trismic1137483trismic
trismus935563trismus
trisome9310223trisome
trisomy1235943trisomy
tristate8311033tristate
triste63818643tris_te
tristeza1742933tristeza
tristich1348423tristich
trite54730033trite__
tritely1039003tritely
triter65120593trite_r
trivets103911583trivets
truest64816193tr_uest
trust55426853trus__t
tryst84716223trys__t
twinset1039373twinse_t
twist86820983twis__t
vivisect1643783vivisect
wisent93516343_wisent
wisest95016443_wisest
wriest94419713wri_est
wrist84827563wris__t

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 Limit1340271706.65620136.3
3Display Results1701700.0632698.4
 (SQL Overall)1786911707.12525079.4
 
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.