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

531 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
troupes9411285(None) 
croupes114613101croupes
trompes114111621trompes
tropes84824351tro_pes
troupe84812431troupe_
trouped103910981trouped
trouper93811431trouper
troupers10359441troupers
arouses74921292arouses
coupes105022522_coupes
croupe105114432croupe_
croups104312552croup_s
croutes94815652croutes
drupes94912652dr_upes
gropes95220402gro_pes
grouped11419192grouped
grouper104210092grouper
groupers11358642groupers
groupies1137522groupies
groups94210512group_s
grouses84616542grouses
loupes84918052_loupes
ropes75940062_ro_pes
roues56039352_rou_es
rouges76022382_rouges
rouped95717352_rouped
roupet84218342_roupet
roups75118902_roup_s
rouses65436282_rouses
routes66129312_routes
taupes8212672t_aupes
thorpes125010352thorpes
topes76941762t_o_pes
toupee8316132t_oupee
toupees938512t_oupees
touses64229672t_ouses
trapes85024462tr_apes
tripes85324872tr_ipes
triunes74311382triunes
troches123715342troches
trokes104019262tro_kes
trompe105611262trompe_
tromped124210292tromped
tromps104911702tromp_s
trones65629282tro_nes
trooped104010722trooped
trooper94210362trooper
troopers10289442troopers
troops85712782troop_s
trope75725802tro_pe_
troubles1057202troubles
troughs11698692troughs
trounces1037062trounces
trouser73812472trouser
trousers83910632trousers
trouts66116632trou_ts
troves94719112tro_ves
truces84916332tr_uces
trues54925322tr_u_es
arbutes939703arbutes
arcuses94814693arcuses
argues74516413argu_es
arguses84711743arguses
armures9510273armures
arouse65019983arouse_
aroused84914353aroused
arouser74514423arouser
arousers84810983arousers
blouses94014463blouses
boules84925973_boules
bouses84931783_bouses
brogues10719823brogues
bromes104719763bro_mes
bronzes183510403bronzes
broses86524403bro_ses
browses124712693browses
brumes106417073br_umes
brutes86118683br_utes
bruxes154811023br_uxes
carouses10614503carouses
chouses125117813chouses
copes97747103_co_pes
coupe96023483_coupe_
couped115019313_couped
couples115317053_couples
coups95522473_coup_s
crapes104727693cr_apes
crepes105419343cr_epes
cripes105120873cr_ipes
crocuses1239023crocuses
crones84729243cro_nes
cronies9622513cronies
cropped143812073cropped
cropper133312973cropper
croppers143311483croppers
croppies143111153croppies
crops96125243cro_p_s
crores86121163cro_res
crosses94220803crosses
crouches153711293crouches
croup95616783croup__
croupier1246893croupier
croupiers1334653croupiers
croupiest1337063croupiest
croupous1245923croupous
croupy13458733croup_y
crouse84619373crouse_
croute84617273croute_
crozes174417663cro_zes
cruces105117543cr_uces
crudes96218623cr_udes
cruses88127713cr_uses
cruxes154911563cr_uxes
dopes84935043_do_pes
douses74928933_douses
drapes95419653dr_apes
drogues9398393drogues
drones75023433dro_nes
drooped11368433drooped
droops95110963droop_s
dropped13329293dropped
dropper12329873dropper
droppers13318603droppers
drops85719503dro_p_s
drosses84513823drosses
drouked1335543drouked
drouks1137123drou_ks
drouths11436483drouths
droves105116673dro_ves
drowses114610233drowses
drupe85012993dr_upe_
druses75517253dr_uses
dupes86425933__dupes
elopes85918163elo_pes
erodes74819883ero_des
eroses65327063ero_ses
erupts8348903er_upts
frappes14328383frappes
froes86126693fro__es
frontes104214163frontes
frounces1336183frounces
gouges86318693_gouges
grapes95123123gr_apes
graupel1034133graupel
graupels1133103graupels
gripes94619873gr_ipes
grippes124810373grippes
grooves11368803grooves
grope84821613gro_pe_
groped107515063gro_ped
groper94517253gro_per
gropers104813853gro_pers
grosses84517683grosses
grouches14328213grouches
grounds9228313grounds
group85413923group__
groupie1045783groupie
grouse74315023grouse_
groused94712843groused
grouser84513693grouser
grousers93810733grousers
grouted94111503grouted
grouter84412523grouter
grouters95910093grouters
grouts75015613grou_ts
groves104318103gro_ves
groynes1137823groynes
grues65721963gr_u_es
grumes94415553gr_umes
hopes105835643_ho_pes
houses96032283_houses
irones64724013iro_nes
ironies7517423ironies
irrupts943733irrupts
joules134116823_joules
jupes145218553__jupes
lopes76437343_lo_pes
louies64525103_louies
loupe75319513_loupe_
louped95316383_louped
loupen84510293_loupen
loups75319623_loup_s
louses66230283_louses
mopes95134983_mo_pes
moues75732843_mou_es
mouses85531423_mouses
myopes13419963myo_pes
nouses64627163_nouses
opes65942613__o_pes
ordures856473ordures
oroides8311973oroides
ouphes113614633__ouphes
ouphs104311273__ouphs
popes95933813_po_pes
probes104119453pro_bes
procures1239213procures
produces1347903produces
proles84627203pro_les
prompts1337473prompts
propel103714063pro_pel
propels113412843pro_pels
proper104319953pro_per
propers113619033pro_pers
propped113311963propped
props95726883pro_p_s
proses84733473pro_ses
prosper114012193prosper
prospers123012263prospers
prosses94019513prosses
prouder10310383prouder
proudest1138943proudest
proves114322253pro_ves
proxies163014933proxies
prudes94215443pr_udes
prunes83419063pr_unes
pyropes142210193pyro_pes
rapes75740723_r_apes
reroutes8312223reroutes
reuses66025523_reuses
rhuses94911793_rhuses
ripes75435773_r_ipes
robes75133303_ro_bes
robles85321693_robles
rodes614039083_ro_des
roes45954143_ro__es
rogues74617673_rogues
roles56747983_ro_les
romped114513653_romped
romper104213683_romper
rompers113412243_rompers
romps94617543_romp_s
rooses65526243_rooses
rope65542913_ro_pe_
roped84630813_ro_ped
roper75431913_ro_per
ropers84325903_ro_pers
ropey106021873_ro_pey
roques154912563_roques
roses56445773_ro_ses
rotes56143903_ro_tes
rottes64524833_rottes
roubles93413513_roubles
rouches124217893_rouches
roue45941743_rou_e_
rouen54920903_rou_en
rouens64814443_rouens
rouge65423443_rouge_
rouged86717323_rouged
roughs105416223_roughs
rounds73615623_rounds
roup66627693_roup__
roupier9319493_roupier
roupiest102610293_roupiest
roupy106112713_roup_y
rouse56634703_rouse_
roused75426453_roused
rouser65224083_rouser
rousers75220143_rousers
rousts617016723_rousts
route55132073_route_
routed75624333_routed
router65025843_router
routers74822873_routers
rouths95416823_rouths
routs57133413_rou_ts
roves84834483_ro_ves
rubes74928413_r_ubes
rues46044483_r_u_es
rules55234253_r_ules
runes55530223_r_unes
rupee7321283_r_upee
rupees8312573_r_upees
ruses56136583_r_uses
scopes104719593sco_pes
scouses93313243scouses
scrouges1136683scrouges
shoppes143411403shoppes
slopes84820453slo_pes
souped95017673_souped
soups75322943_soup_s
souses64229243_souses
spouses92912813spouses
stopes84525893sto_pes
stoups85313273stoup_s
stoures74614163stoures
stripes95320573str_ipes
strobes93813263stro_bes
strokes114316323stro_kes
strophes13310603strophes
stropped1367353stropped
stropper1247763stropper
stroppers1356723stroppers
strops86220383stro_p_s
strouds837803strou_ds
stupes84116953_stupes
supes75628303__supes
talipes9611603talipes
taluses7311213taluses
tapes75838603t__apes
tartufes1164153tartufes
taupe7314173t_aupe_
tenues63816443tenu_es
tenures7412013tenures
tholes94919783tho_les
thorpe113610093thorpe_
thorps113610893thorp_s
thoued10429003thou_ed
thous86017263thou__s
throes97518673thro__es
thrones105715843thro_nes
tobies84521023t_obies
todies74223553t_odies
toes46956443t_o__es
togues76014243t_ogues
toiles63923513t_oiles
tokes95234973t_o_kes
toles55147133t_o_les
tomes76037383t_o_mes
tones56048663t_o_nes
tonnes65320853t_onnes
tonuses73612193tonuses
toonies73719883toonies
tootles72915603tootles
tootses72910773tootses
tope65946383t_o_pe_
toped85631313t_o_ped
topee76029953t_o_pee
topees85519703t_opees
toper75231023t_o_per
topers85025323t_o_pers
tophes115218423t_ophes
tophs105220053t_o_phs
topis76025833t_o_pis
topos75726393t_o_pos
topped114617723t_opped
topper103817603t_opper
toppers113914603t_oppers
topples113111653t_opples
tops66248123t_o_p_s
toques154612353t_oques
torches123715443torches
tores55352673t_o_res
tories65435883t_ories
torous64319033torou__s
torques16217513torques
torses64727953t_orses
tortes64826053t_ortes
tortures838913tortures
torulas759853torulas
torus54329763toru__s
toshes94520103t_oshes
tosses65225393t_osses
totes55139683t_o_tes
touches125118343t_ouches
toughs105414993t_oughs
toured74216153t_oured
tourer64115073t_ourer
tourers73512743t_ourers
tours55325893t_ou_rs
touse55430673t_ouse_
toused74122013t_oused
tousles74113933t_ousles
touted74419743t_outed
touter63821033t_outer
touters74018353t_outers
touts54830393t_ou_ts
touzles16359223t_ouzles
towies93521193t_owies
towropes1344953towro_pes
traces85329933tr_aces
trades75724503tr_ades
traduces1136563traduces
traipse935873traipse
traipses1036873traipses
tramped124312433tramped
tramper113812163tramper
trampers123210393trampers
tramples122610203tramples
tramps105114453tramp_s
trances93919643trances
trapped124512213trapped
trapper113912803trapper
trappers123711043trappers
traps75727483tr_ap_s
trashes104119263trashes
trasses74819323trasses
traumas938593traumas
traves94222743tr_aves
trebles9311443trebles
trees55835763tr__ees
tres46542903tr___es
tresses73719543tresses
triages82613793triages
tribes85119023tr_ibes
tribunes1055863tribunes
tributes1047233tributes
triceps11267343triceps
trices84826333tr_ices
trienes74118413trienes
tries55742813tr__ies
trifles103814823trifles
trikes105419493tr_ikes
trines64132563tr_ines
triodes84012503triodes
trioses75015653trioses
tripe75425383tr_ipe_
triples94616873triples
tripos84014923tr_ipos
tripped123911693tripped
tripper113711923tripper
trippers123210163trippers
trippet113714113trippet
trippets12357423trippets
trips74923363tr_ip_s
triumphs1542513triumphs
triune64210183triune_
troaked12438253troaked
troaks104410603tro_aks
trocars959043trocars
troche113112513troche_
trochee122613883trochee
trochees132510183trochees
trocked144312243trocked
trocks123614633tro_cks
trodden934883trodden
trode65322853tro_de_
troffer13125863troffer
troffers14125433troffers
trogons83410723trogons
trogs67022603tro__gs
troikas1135033troikas
troilus736413troilus
troiluses944553troiluses
trois57226093tro__is
troke94821053tro_ke_
troked114114583tro_ked
trolled84312263trolled
troller73913173troller
trollers83211213trollers
trolley10328753trolley
trolleys11315693trolleys
trollies8310233trollies
trolls64613943tro_lls
trommel11315363trommel
trommels12254333trommels
tromp95815803tromp__
tronas63816903tro_nas
trone55131863tro_ne_
troop76417533troop__
trop66833303tro_p__
trophies13413683trophies
trophy1438283tro_phy
tropic103014193tro_pic
tropics113610653tropics
tropin83316753tro_pin
tropines102214923tropines
tropins93116313tropins
tropism1139293tro_pism
trothed114010973trothed
troths95414153tro_ths
trots56629943tro__ts
trotted83711283trotted
trotter73312253trotter
trotters83310253trotters
trotyls10236033trotyls
trouble957713trouble
troubled1134983troubled
troubler1035293troubler
troublers1135003troublers
trough108512033trou_gh
trounce936823trounce
trounced1135033trounced
trouncer1035443trouncer
trouncers1134813trouncers
troupial1044183troupial
troupials1142933troupials
trouping11249503trouping
trout57332573trou__t
troutier8277153troutier
troutiest9127803troutiest
trouty95211793trou_ty
trouvere1144073trouvere
trouveres1243773trouveres
trouveur1141673trouveur
trouveurs1241643trouveurs
trove85221923tro_ve_
trover95014663tro_ver
trovers103713323trovers
trowed104714653tro_wed
trowel94211463tro_wel
trowels10358363trowels
trows88826183tro__ws
trowsers11428003trowsers
trowths1365023trowths
troys86418613tro__ys
truce75118693tr_uce_
truced95312053tr_uced
trucks124711973tr_ucks
trudges9339993trudges
true46725853tr_u_e_
trued65117693tr_u_ed
truer54916643tr_u_er
truest64816193tr_u_est
truffes1356773truffes
trugs65516803tr_u_gs
trulls64110283tr_ulls
trumped12439713trumped
trumpet113810723trumpet
trumpets12315573trumpets
trumps104611883tr_umps
trunks10429753tr_unks
truss54916923tr_u_ss
trusses73813643trusses
trusts64714433tr_usts
truths9449503tr_uths
tryouts1035313tryou_ts
trystes10419993trystes
tsores65113663tso_res
tsouris735153tsouris
tubes74826453t__ubes
tubules9310233tubules
tules54532793t__ules
tunes55332193t__unes
tups65628763t__up_s
tuques15358373tuqu_es
turnups933893turnup_s
tuxes124316043t__uxes
types105721063t__ypes
uprouses1037553uprouses
uruses63616503ur_uses
vrouws12494743vrou_ws

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.423422437.4
2DLD Change Limit1340275316.75019855.9
3Display Results5315310.1862854.8
 (SQL Overall)1786915317.35924282.0
 
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.