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

215 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
trientes8281212(None) 
trienes74118411trien_es
ariettes8411352ariettes
oriented937482oriented
orienter838312orienter
orienters937612orienters
orients7311582orient_s
rentes65431192_r_entes
tributes1047232tributes
tridents938582trident_s
triene64316382trien_e_
triens65417542trien__s
trines64132562tri_n_es
triunes74311382triun_es
alienates9310683alienates
alienees8118653alienees
arenes64928393ar_en_es
arenites8917103ar_enites
aretes64425353ar_e_tes
argents84014853argent_s
ariettas847393ariettas
ariette7312373ariette_
arpents93613083arpent_s
arsenates979373arsenates
arsenites9149163arsenites
brents84717273br_ent_s
brines85028853bri_n_es
brinies93317913bri_nies
brionies10310543brionies
clients938093client_s
creates95225203cr_eates
cringes103215503cri_nges
crinites10612763crinites
detentes92712873detentes
dienes75719903_dien_es
ententes8312773ententes
faiences1337043faiences
friended1335033friended
friends11396743frien_ds
friezes19418913frie_zes
frigates12310933frigates
fringes113514103fri_nges
frisettes1295353frisettes
frites94922483fri__tes
frizettes2193493frizettes
frontes104214163fr_ontes
gentes75324163__gentes
greenies9312673greenies
greenths1295213greenths
grieves1137323grie_ves
grisettes1094713grisettes
kentes105118653__kentes
nutrients944423nutrient_s
orient6322533orient__
oriental848483oriental
orientals946903orientals
orientates1046043orientates
orienteer943213orienteer
orienteers1042693orienteers
parietes10714543parie_tes
pointes93216753poi_ntes
priested1138393priested
priestess1145293priestess
priests93810863priest_s
primates121515933primates
princes113015143pri_nces
printed104016373pri_nted
printer93917303pri_nter
printers103214903pri_nters
prints84320103pri_nt_s
privates131812373privates
proettes10312763proettes
quintes164114713qui_ntes
reenter73217793_reenter
reenters82915303_reenters
reinter73116843_reinter
reinters82614773_reinters
rente54733783_r_ente_
rented74426593_r_ented
renter64527413_r_enter
renters74224813_r_enters
rents55935183_r_ent_s
rinses64720383_ri_nses
rites54442553_ri__tes
sciences1238773sciences
sienites8311913_sienites
sirventes1244903sirventes
striates83417083stri_ates
stridences1344733stridences
tainted83512423tai_nted
taints64520533tai_nt_s
talented938423talented
talents7312013talent_s
tenets65518953t__enets
tenses64722553t__enses
tented74221003t__ented
tenter64623933t__enter
tenters73921103t__enters
tenths94412663t__enths
tents56434213t__ent_s
tenues63816443t__enues
terpenes102111573terpen_es
terrenes82212603terren_es
testes65125823t__estes
theines104013233thein_es
thieves1346903thie_ves
thionates12106663thionates
tierces93710453t_ierces
tines54848423t_i_n_es
tinges74722333t_i_nges
tinted74419533t_i_nted
tinter63923643t_i_nter
tinters74221113t_i_nters
tints56030923t_i_nt_s
toilettes946023toilettes
tonettes839203tonettes
tormented1245963tormented
tormenter1146703tormenter
tormenters1245823tormenters
torments10310453torment_s
torrents838143torrent_s
trainees82712063trainees
trances93919643tr_ances
trannies8415013trannies
treated83618703tr_eated
treater74219833tr_eater
treaters83615843tr_eaters
treaties8316983tr_eaties
treats64821693tr_eat_s
trebles9311443tr_ebles
trecentos1155873trecentos
treens65317873treen__s
trees55835763tr_e__es
trenches133512603tr_enches
trended94011763tr_ended
trendies9312213tr_endies
trends75513543tr_en_ds
tresses73719543tr_esses
trestles83012553tr_estles
trets55928023tr_e_t_s
trevets10499973tr_evets
triages82613793tri_ages
triangles1035743triangles
tribades1136893tribades
tribes85119023tri__bes
tribunates1244173tribunates
tribunes1055853tribunes
tribute937313tribute_
tricepses1354643tricepses
trices84826333tri__ces
trichites1448883trichites
trickles143013763trickles
tricots9311563tricot_s
trident8314193trident__
tridental1046623tridental
triennia844563triennia
triers64321523trie__rs
tries55742813tri___es
trifectas1443653trifectas
trifles103814823tri_fles
trigness968403trigness
trijets14308263trijet_s
trikes105419493tri__kes
trilbies1037693trilbies
triliths1145953triliths
trimester1145823trimester
trimesters1245413trimesters
trimeter10310083trimeter
trimeters1139213trimeters
trimness1067563trimness
trindles93211683trindles
trine54734603tri_n_e_
trined74920713tri_n_ed
trinities9313343trinities
trinket11314813tri_nket
trinkets1237143tri_nkets
triodes84012503tri_odes
triolets83410143triolets
trioses75015653tri_oses
tripes85324873tri__pes
triples94616873tri_ples
triplets103510263triplets
triplites1148283triplites
triposes1039973triposes
trippets12357423trippets
triremes1035523triremes
trisected1244913trisected
trisects1035983trisect_s
trisemes1036643trisemes
trisomes1039833trisomes
triste63818643tri_ste_
trite54730033tri__te_
triteness9310363triteness
triter65120593tri__ter
tritest7315273tri__test
tritones83413443tritones
triune64210183triun_e_
triunities1046103triunities
trivets103911583trivet_s
troilites948433troilites
trones65629283tr_on_es
trounces1037063trounces
truanted935373truanted
truants738163truant_s
trueness838693trueness
trystes10419993tr_ystes
tweenies11146393tweenies
twenties1137503t_wenties
twines94717273twi_n_es
twinges11409453twi_nges
urinates8314133urinates
urines64724123uri_n_es
wienies102213683_wienies
writes94420333wri__tes
yentes95517603__yentes

Search took 9 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 Limit1461622157.81318707.5
3Display Results2152150.0932311.8
 (SQL Overall)1786912158.32921454.1
 
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.