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

464 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
trevets1049997(None) 
brevets12519391brevets
revets94022171_revets
trevet94818911trevet_
trivets103911581trivets
breves115516422breve_s
brevet115717332brevet_
greets75117422gre_ets
grivets11357972grivets
presets94216422presets
prevents133012292prevents
privets122910052privets
relets64025672_relets
resets65427612_resets
revels94220572_revels
revers94529632_revers
reverts104715042_reverts
revest94623602_revest
revests104413732_revests
revet84938842_revet_
rewets94617212_rewets
rivets94417112_rivets
streets73312612stre_ets
tenets65518952t_enets
tercets93512442tercets
terrets72913582terrets
travels104711292travels
traves94222742trave_s
treats64821692tre_ats
treens65317872tre_ens
trees55835762tre_e_s
trets55928022tr__ets
trijets14308262trijets
trivet93721882trivet_
trovers103713322trovers
troves94719112trove_s
tweets94210102twe_ets
vervets13419752vervets
afreets1037013afre_ets
arenes64928393arene_s
aretes64425353arete_s
armets84918353ar_mets
armlets94610063armlets
beets76131443_be_ets
beeves114615043beeve_s
begets96215523_begets
berets85822523_berets
besets85718803_besets
bevels113913983_bevels
bravers124715523bravers
braves115524083brave_s
bravest124211753bravest
breasts939703breasts
bredes94818473brede_s
breeds94914883bre_eds
breeks125310793bre_eks
brees75632553bre_e_s
brents84717273bre_nts
breve105317053breve__
brevetcy1841723brevetcy
breveted1435623breveted
breviers1335923breviers
brevity1534783brevity
brewers123811063brewers
brunets9419553brunets
cermets1139713cermets
chevrets16255323chevrets
civets115212543_civets
corvets124715023corvets
covets114819643_covets
cravats1237403cravats
cravens124010123cravens
cravers124416563cravers
craves115825393crave_s
creates95225203creates
credits1039973credits
creeds94714773cre_eds
creeks124812923cre_eks
creels84416943cre_els
creeps104213623cre_eps
cremes104517993creme_s
crenels93711013crenels
crepes105419343crepe_s
cressets10309103cressets
crests85218703cre_sts
crewels12438493crewels
cruets85314953cr_uets
crusets93811043crusets
curvets12399913curvets
deets65330243_de_ets
devels104313903_devels
devest104418703_devest
devests114410473_devests
drees65628523dre_e_s
drivels11397923drivels
drivers114412793drivers
drives105117113drive_s
drovers115212643drovers
droves105116673drove_s
duvets1039223_duvets
elevens1066803elevens
entremets1147143entremets
erects84116183ere_cts
evens84817103__evens
events94814073__events
everts94514893__everts
eves76230463__eve_s
eyelets1057523eyelets
ferrets103111393ferrets
fevers125414893_fevers
fleets96915063fle_ets
forevers1438173forevers
freers94717303fre_ers
frees86131393fre_e_s
freest95318283fre_est
freres94716173frere_s
freshets14298673freshets
frets85523403fr__ets
genets75716663_genets
gleets75315053gle_ets
gravels113611143gravels
gravers114515273gravers
graves104624003grave_s
gravest114011633gravest
greats76318393gre_ats
greaves113311443greave_s
grebes93813613grebe_s
greeds84314283gre_eds
greens75716873gre_ens
grees65132473gre_e_s
greet65835323gre_et_
greyest11348343greyest
grievers1255473grievers
grieves1137323grieve_s
grivet103517823grivet_
grovels11427813grovels
groves104318103grove_s
ireless72312243ireless
keets95123483_ke_ets
keeves133711993keeve_s
kevels134410713_kevels
kreeps12427413kre_eps
krewes1337923krewe_s
leets54927123_le_ets
levees93714523_levees
levels94113283_levels
levers94621323_levers
lievest1048343lievest
meets74224613_me_ets
nerves94216193nerve_s
neves87021873_neve_s
nieves94311293nieve_s
omelets938333omelets
peeves113814873peeve_s
perverts1337533perverts
preacts113211363preacts
preavers13910263preavers
precents123015043precents
precepts14268893precepts
precess11310863precess
precuts111710473precuts
preens85020113pre_ens
prees75937173pre_e_s
prefects1598133prefects
prefers123713333prefers
preheats1339413preheats
prelects1299723prelects
premeds12389593premeds
presents103315643presents
preset84430983preset_
prests84021263pre_sts
pretest9517633pretest
pretests10310013pretests
pretexts1735603pretexts
prevent124016553prevent
preverb14317063preverb
preverbs15295303preverbs
previews1634513previews
prevues1239263prevues
prexes154915953prexe_s
preyers124412363preyers
prezes173614693preze_s
privet113821343privet_
projets1639163projets
provers123817793provers
proves114322253prove_s
ramets83517393_ramets
ravels94717073_ravels
ravens93916883_ravens
ravers94628183_ravers
raves85441973_rave_s
reacts83616603_reacts
reavers108320743_reavers
reaves94127573_reave_s
rebecs103913673_rebecs
rebels84518133_rebels
rebuts84015193_rebuts
recepts113010263_recepts
recess8314263_recess
recits83621353_recits
recuts83817373_recuts
redes65139133_rede_s
reeds65430903_re_eds
reefs85121663_re_efs
reeks94124033_re_eks
reels55333263_re_els
rees45364193_re_e_s
reest54938093_re_est
reests64618893_reests
reeves94721493_reeves
refects124012743_refects
refels94618053_refels
refers93921083_refers
refits94017653_refits
reflets103513153_reflets
regents83416543_regents
reges65628793_rege_s
reglets83512983_reglets
regrets83212923_regrets
reheats104513523_reheats
rehems113410983_rehems
reivers105117083_reivers
reives95723043_reive_s
rejects163910693_rejects
rekeys13347693_rekeys
relents74018503_relents
relet54749823_relet_
remeets93712413_remeets
remelts93511493_remelts
remet74843723_remet_
remits85622943_remits
renest64529713_renest
renests74014213_renests
renews93811753_renews
rennets75212633_rennets
rentes65431193_rentes
rents55935183_re_nts
repeats94316053_repeats
repegs93311943_repegs
repels84318763_repels
repents93717623_repents
repots85621003_repots
rerents73319423_rerents
reseats74319583_reseats
resects94115593_resects
resees63827483_resees
resents74221223_resents
reset55051863_reset_
resews94814173_resews
resits64725563_resits
rests54935873_re_sts
retems83914573_retems
retest64028453_retest
retests73813853_retests
rets45352563_r__ets
reveal94115053_reveal
reveals103812723_reveals
revel84423163_reve_l
reverb113912573_reverb
reverbs12368863_reverbs
revere94621253_revere
reveres103621343_reveres
reverse103913743_reverse
reverso10367693_reverso
revert93529113_revert
revery124014213_revery
reviews1335533_reviews
revolts1038893_revolts
revote94917453_revote
revotes104716393_revotes
revs75027053_rev__s
revues9813903_revues
reweds104412303_reweds
rewet85135153_rewet_
rexes124526953_rexe_s
rievers104311453rievers
rivers94626543_rivers
rives85336003_rive_s
rivet85636363_rivet_
rosets65819953_rosets
rovers95423523_rovers
roves84834483_rove_s
servers103214833servers
serves94423653serve_s
sevens93813663_sevens
severs94121123_severs
sheets93918503she_ets
sieverts1145713sieverts
sieves93216003sieve_s
skeets104513253ske_ets
sleets64318873sle_ets
steeves103410903steeve_s
sterlets8169273sterlets
streeks11378713stre_eks
streels73811343stre_els
street64125773stre_et_
strewers11409063strewers
strivers113911843strivers
strives104119373strive_s
sweets94214433swe_ets
swevens1334613swevens
swivets13436963swivets
tablets94714383tablets
tackets134914363tackets
tappets113610013tappets
targets84314223targets
tartlets8289663tartlets
tassets75012773tassets
teats55636813t_e_ats
teels55726373t_e_els
teemers95012903teemers
teems76019783t_e_ems
teeners74415453teeners
teens56227483t_e_ens
teepees939263teepees
tees45353583t_e_e_s
teeters74018303teeters
teeth87315853t_e_eth
teles54536003t_ele_s
telnets738373telnets
tempts10439453t_empts
tenet55542213t_enet_
tents56434213t_e_nts
tepees84215243t_epees
tercelets1144813tercelets
tercels94110363tercels
terces83921413terce_s
tercet83624913tercet_
terete6319333t_erete
termers95414503termers
ternes65422903terne_s
terret63425623terret_
territs72714503territs
tersest71713993tersest
testes65125823t_estes
tests56530193t_e_sts
tets45847463t___ets
texts125515043t_e_xts
thebes115914493thebe_s
thefts12387923the_fts
theists1039153theists
themes115319253theme_s
theres96525473there_s
thereto1038993thereto
theses96517973these_s
thieves1346903thieve_s
thraves13469713thrave_s
threats104311673thre_ats
threeps12687043thre_eps
threes97117323thre_e_s
thrivers14456823thrivers
thrives134611713thrive_s
tickets134113683tickets
tieless72512563tieless
tippets11339373tippets
tiredest938403tiredest
tireless82510263tireless
tmeses85712243tmese_s
toeless72612393toeless
toilets74112913toilets
tonlets73212503tonlets
toquets16367863toquets
tracers94917843tracers
traces85329933trace_s
tracts85019073tr_acts
traders84316953traders
trades75724503trade_s
traits65121983tr_aits
trajects1744533trajects
tramels93812493tramels
trapes85024463trape_s
trave85223033trave__
travel94112983trave_l
traverse1136213traverse
travesty1444483travesty
travois1037883travois
treaders93311843treaders
treads74817923tre_ads
treat56240353tre_at_
treated83618703treated
treater74219833treater
treaters83615843treaters
treaty94414353tre_aty
trebles9311443trebles
trecento1066213trecento
trecentos1155873trecentos
tree47745813tre_e__
treed65626733tre_e_d
treeless839283treeless
treen55622753tre_e_n
treetop945523tre_etop
treetops1045463tre_etops
trekkers1133803trekkers
treks96016853tr__eks
trellis739873trellis
tremors93711233tremors
trends75513543tre_nds
trepans92311593trepans
tres46542903tr__e_s
tress55423163tr__ess
tressels8367653tressels
tresses73719543tresses
tret46653533tr__et_
trews86118893tr__ews
treys85018213tr__eys
tribes85119023tribe_s
triceps11267343triceps
trices84826333trice_s
tricots9311563tricots
tridents938583tridents
trienes74118413triene_s
triens65417543tr_iens
trientes82812123trientes
triers64321523tr_iers
tries55742813tr_ie_s
trijet133916553trijet_
trikes105419493trike_s
trimers94615143trimers
trines64132563trine_s
trinkets1237143trinkets
triolets83410143triolets
tripes85324873tripe_s
triplets103510263triplets
trippets12357423trippets
trisects1035983trisects
tritest7315273tritest
trokes104019263troke_s
trones65629283trone_s
tropes84824353trope_s
trots56629943tr__ots
trouts66116633tr_outs
trove85221923trove__
trover95014663trove_r
trowels10358363trowels
truants738163truants
truces84916333truce_s
trueness838693trueness
trues54925323tr_ue_s
truest64816193tr_uest
trumpets12315573trumpets
trusts64714433tr_usts
tryouts1035313tryouts
trystes10419993trystes
trysts9448793tr_ysts
tuckets134810333tuckets
tuffets13266523tuffets
tureens7289873ture_ens
turrets73010673turrets
turves94212693turve_s
tweeds10498433twe_eds
tweens9489843twe_ens
tweet84823983twe_et_
twelves1334303twelve_s
tyees86019453tye_e_s
typesets1343213typesets
ureters7311823ureters
velvets13326693velvets
versets103913103versets
verves124617883verve_s
vervet124619063vervet_
vets76835093___vets
weets85427723_we_ets
weevers13379993weevers
wrests95313083wre_sts

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.436409841.7
2DLD Change Limit1340274646.98319193.3
3Display Results4644640.1732682.1
 (SQL Overall)1786914647.59223536.7
 
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.