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

233 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
triolets8341014(None) 
triolet73219521triolet_
triplets103510261triplets
driblets11266092driblets
orioles7412992oriole_s
piolets93513192_piolets
riblets93412552_riblets
rillets74216152_rillets
toilets74112912toi_lets
triflers113110222triflers
trifles103814832trifle_s
trijets14308262tri_jets
trillers83613492trillers
trinkets1237142trinkets
triodes84012502triode_s
triols66117802triol__s
trioses75015652triose_s
triples94616872triple_s
triplet94319212triplet_
trippets12357422trippets
trivets103911582tri_vets
violets102210002_violets
aiglets84012913_aiglets
areoles71016953areole_s
armlets94610063ar_mlets
billets94516153_billets
bricoles122610303bricole_s
bridlers11359183bridlers
bridles104114473bridle_s
brimless1235273brimless
briolette1144193briolette
briolettes1243863briolettes
briquets1934853briquets
briskets14346563briskets
broilers103210093broilers
brooklets1543683brooklets
cabriolets1463383cabriolets
carioles10817083cariole_s
circlets1235663circlets
creoles9913323creole_s
crickets16418123crickets
criollos1043713criollos
darioles9710703dariole_s
dribblets14294143dribblets
driblet103712243driblet_
drillers9429723drillers
dripless1135243dripless
droplets1136063droplets
filets94718953_fi_lets
fillets103414753_fillets
frijoles1834373frijole_s
frillers11349873frillers
friskets15326263friskets
frivolers1543473frivolers
froglets1235263froglets
fruitlets1243173fruitlets
giblets103210423_giblets
giglets93211553_giglets
gimlets10338433_gimlets
grillers93810813grillers
grilles83715023grille_s
griots74713643grio__ts
grivets11357973gri_vets
idiolects1243083idiolects
inlets63915573__inlets
islets64513083__islets
millets94216843_millets
oriole6814293oriole__
piglets103311793_piglets
piolet83225643_piolet_
prickets16329083prickets
prioress1035393prioress
privets122910053pri_vets
projets1639163pr_ojets
prolegs10379993pr_olegs
proles84627203pr_ole_s
quillets17256823quillets
reflets103513153_reflets
reglets83512983_reglets
relets64025673_r_elets
ribless93410343_ribless
riblet84222443_riblet_
rickets134915093_rickets
ridleys11145783_ridleys
riflers103512203_riflers
rifles94217713_rifle_s
riles55343643_ri_le_s
rilles64725503_rille_s
rillet64828853_rillet_
rimless9369363_rimless
ringlets92910243_ringlets
rioters73615523_rioters
riots54922013_rio__ts
ripplets12316733_ripplets
rivets94417113_ri_vets
rivulets1174753_rivulets
roles56747983_r_ole_s
rootlets8308653_rootlets
rosets65819953_r_osets
runlets73310773_runlets
skillets12226823skillets
sniglets9276813sniglets
tablets94714383t_ablets
taborets10278073taborets
tailers73720183tai_lers
tailles72516473taille_s
tailless8239083tailless
tartlets8289663tartlets
templets12226143templets
tercelets1144813tercelets
thickets17287083thickets
thiols95112763thiol__s
tholes94919783t_hole_s
thrillers1244473thrillers
tickets134113683t_ickets
tieless72512563t_ieless
tilers63523503t_i_lers
tiles55542103t_i_le_s
tillers73418743t_illers
tilts55325613t_i_l_ts
tipless92610063t_ipless
tippets11339373t_ippets
tireless82510263tireless
titles63719923t_itle_s
toilers74116263toi_lers
toiles63923513toi_le_s
toilet66228093toi_let_
toles55147133t__ole_s
tonlets73212503t_onlets
toolers74416503t_oolers
townlets1134773townlets
trailers82912933trailers
trailless935973trailless
tramless1037503tramless
trawlers113310203trawlers
trawleys14284383trawleys
trawlnets1242843trawlnets
trebles9311443treble_s
treeless839283treeless
trets55928023tr___ets
trevets10499983tr_evets
triages82613793triage_s
trials64319883trial__s
triazoles1844393triazole_s
tribes85119023tri_be_s
tributes1047233tributes
triceps11267343tri_ceps
trices84826333tri_ce_s
trickers143812813trickers
trickles143013763trickle_s
triclads1146233triclads
tricolette1253603tricolette
tricolettes1353283tricolettes
tricolors11125803tricolors
tricots9311563tri_cots
tridents938583tridents
trienes74118413triene_s
triens65417543tri__ens
trientes82812133trientes
triers64321523tri__ers
tries55742813tri__e_s
trifle94012883trifle__
trifled113711963trifle_d
trifler103912153trifle_r
triggers10257843triggers
triggest1036923triggest
trigness968403trigness
trijet133916553tri_jet_
trikes105419493tri_ke_s
trilith10310513tri_lith
triliths1145953tri_liths
trilled84116313trille_d
triller74215893trille_r
trills64319853tri_l_ls
trimers94615143tri_mers
trimmers12288913trimmers
trimmest12227023trimmest
trimness1067563trimness
trindles93211693trindle_s
trines64132563tri_ne_s
trinket11314813trinket_
triode75311893triode__
triol55521363triol___
trios55528093trio___s
triose64715383triose__
trioxids1644443trioxids
tripes85324873tri_pe_s
triple84215923triple__
tripled104113833triple_d
triplex16447803triple_x
triplexes1844253triplexes
triplite1039103triplite
triplites1148283triplites
tripolis1038713tripol_is
triposes1039973tripose_s
trippers123210163trippers
trippet113714113trippet_
trisects1035983trisects
trisomes1039833trisome_s
tritest7315273tri_test
tritones83413443tritone_s
triunes74311383triune_s
trivet93721883tri_vet_
troilite849543troilite
troilites948433troilites
troilus736413troil_us
trokes104019263tr_oke_s
trollers83211213trollers
trolleys11315693trolleys
trolls64613943tr_ol_ls
trones65629283tr_one_s
troopers10289443troopers
tropes84824353tr_ope_s
trots56629943tr_o__ts
trouts66116633tr_o_uts
trovers103713323tr_overs
troves94719113tr_ove_s
trowels10358363tr_owels
trumpets12315573trumpets
tryouts1035313tryo_uts
tuilles72411923tuille_s
turbojets1852553turbojets
twigless1293663twigless
twinjets1842413twinjets
twinsets1133663twinsets
twirlers11274303twirlers
utricles1037223utricle_s
varioles11711133variole_s
veinlets11144833veinlets
violet92620923_violet_
wiglets113411423_wiglets
willets104414323_willets
wristlets1244473wristlets

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 Limit1461622337.01620832.7
3Display Results2332330.0932505.4
 (SQL Overall)1786912337.53223724.2
 
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.