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 “triseme” 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
triseme93654(None) 
trireme935261trireme
trisemes1036641trisemes
trisome9310221trisome
frisee94217992frise_e
prisere9310942prisere
triene64316382tri_ene
triremes1035522triremes
triscele1045432triscele
trisect939732trisect
trisemic1245192trisemic
triskele1244572triskele
trisomes1039832trisomes
trisomy1235942trisomy
triste63818642tris_te
arise56436433aris__e
arisen65316793arise_n
arises65233803arise_s
aristae7312533aristae
bireme10310143_bireme
bribee104316363bribe_e
brises84927613brise_s
bristle91910103bristle
creme94319323cr__eme
crime94822693cri__me
crises84529433crise_s
cristae9310613cristae
disme85716243_dis_me
episome1157813episome
frieze18378143fri_eze
frisbee12298513frisbee
frise85322453fris__e
frisees104411693frisees
frises94124273frise_s
frisette1195483frisette
friseur1033673friseur
grieve1047243gri_eve
grime85021323gri__me
grisette994653grisette
gristle8169223gristle
irised73913153irise_d
irises64221173irise_s
irksome1344373irksome
krises105016083krise_s
noisome947973noisome
presume11310303presume
prime96525603pri__me
prise74632613pris__e
prised94322203prise_d
priseres10310823priseres
prises84133173prise_s
prism94820263pris_m_
prisms104915503pris_ms
raceme1039733_raceme
resee54336333_rese_e
resume8313783_resume
rheme106214053_r_heme
rime65138883_ri__me
rise45945233_ris__e
risen54621883_rise_n
riser55431053_rise_r
risers64624783_risers
rises55244043_rise_s
risque15227453_risque
seme65836653___seme
spireme11478363spireme
tagmeme1243353tagmeme
taxeme1536253t_axeme
theme105921733t__heme
thieve1235963thi_eve
thistle10107803thistle
time66235013t_i__me
tiresome1046993tiresome
tisane6311573t_isane
tissue637333t_issue
toilsome1045203toilsome
toneme8312103t_oneme
trainee72817793traine_e
trapeze1836253trapeze
trashmen1346563trashmen
tree47745813tr__e_e
trestle72611363trestle
triable92515393triable
triage72812893tri_age
tribade1037293tribade
tribe74420273tri__be
tribes85119023tribe_s
tribesmen1342953tribesmen
tribune945573tribune
tribute937313tribute
trice75127493tri__ce
triced95518673trice_d
tricep103911073trice_p
triceps11267343triceps
trices84826333trice_s
trichome1596953trichome
trickie132611033trickie
trickle133613443trickle
trident8314193trident
tried65026913tri_e_d
trienes74118413tri_enes
triens65417543tri_ens
trier54328533tri_e_r
triers64321523tri_ers
tries55742813tri_e_s
trifle94012883tri_fle
trijet133916553trije_t
trijets14308263trijets
trike95320163tri__ke
trikes105419493trike_s
trim65329523tri__m_
trimer85717153trime_r
trimers94615143trimers
trimeter10310083trimeter
trimmed12348933trimmed
trimmer113610833trimmer
trims75021473tri__ms
trindle83311363trindle
trine54734603tri__ne
trined74920713trine_d
trines64132563trine_s
triode75311893tri_ode
triose64715383tri_ose
trioses75015653triose_s
tripe75425383tri__pe
tripes85324873tripe_s
triple84215923tri_ple
trisceles1145293trisceles
trisected1244913trisected
trisects1035983trisects
trishaw1344753trishaw
triskeles1344273triskeles
trismic1137483trismic
trismus935563trismus
trisomic1245943trisomic
trisomies1147163trisomies
tristate8311033tristate
tristeza1742933tristeza
trite54730033tri__te
tritely1039003tritely
triter65120593trite_r
tritest7315273tritest
tritoma948053tritoma
tritone73613883tritone
triune64210183tri_une
trivet93721883trive_t
trivets103911583trivets
truism8118623truis_m_
truisms9106823truis_ms
trustee73514443trustee
tryste9399583trys_te
twasome1244623twasome
twosome1245303twosome

Search took 7 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 Limit1340271536.46620728.0
3Display Results1531530.0463326.1
 (SQL Overall)1786911536.91825829.9
 
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.