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

520 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
troupe8481243(None) 
croupe105114431croupe
trompe105611261trompe
trope75725801tro_pe
trouped103910971trouped
trouper93811411trouper
troupes94112841troupes
arouse65019982arouse
coupe96023482_coupe
croup95616782croup_
croupes114613102croupes
croups104312552croups
croupy13458732croupy
crouse84619362crouse
croute84617272croute
drupe85012992dr_upe
grope84821612gro_pe
group85413922group_
grouped11419192grouped
grouper104210092grouper
groupie1045782groupie
groups94210512groups
grouse74315022grouse
loupe75319512_loupe
rope65542912_ro_pe
roue45941742_rou_e
rouge65423442_rouge
roup66627692_roup_
rouped95717352_rouped
roupet84218342_roupet
roups75118902_roups
roupy106112712_roupy
rouse56634702_rouse
route55132072_route
taupe7314162t_aupe
thorpe113610092thorpe
tope65946382t_o_pe
toupee8316132t_oupee
touse55430672t_ouse
tripe75425382tr_ipe
triune64210182triune
troche113112512troche
trode65322852tro_de
troke94821052tro_ke
tromp95815802tromp_
tromped124210292tromped
trompes114111622trompes
tromps104911702tromps
trone55131862tro_ne
troop76417532troop_
trooped104010722trooped
trooper94210352trooper
troops85712772troops
trop66833302tro_p_
tropes84824352tro_pes
trouble957702trouble
trough108512022trough
trounce936822trounce
troupers10359422troupers
trouser73812462trouser
trout57332572trou_t
trouts66116622trouts
trouty95211792trouty
trove85221922tro_ve
truce75118692tr_uce
true46725852tr_u_e
arbute8311043arbute
argue64818443argu_e
armure8710133armure
arose55832083aro_se
around72712413around
aroused84914343aroused
arouser74514423arouser
arouses74921293arouses
blouse84714723blouse
boule74828043_boule
bouse75931853_bouse
broche133612103broche
brogue94211033brogue
broke116019783bro_ke
brome94421973bro_me
bronze173610923bronze
brose75227033bro_se
browse115713853browse
brume95817983br_ume
brute75321783br_ute
carouse9614423carouse
chouse116017563chouse
cope86847383_co_pe
coude85022633_coude
coup86729793_coup_
couped115019313_couped
coupes105022523_coupes
couple104415963_couple
coups95522473_coups
crape96128443cr_ape
crepe95520723cr_epe
cripe95521143cr_ipe
crone75231333cro_ne
crop87628633cro_p_
cropped143812063cropped
cropper133312963cropper
croppie13278793croppie
crops96125233cro_ps
crore74922863cro_re
crosse85216303crosse
crouch133910203crouch
croupier1246883croupier
croutes94815643croutes
croze164719453cro_ze
crude86018573cr_ude
cruse75726103cr_use
dope76038893_do_pe
douce85518423_douce
douse66329723_douse
drape85319633dr_ape
drogue8938333drogue
drone65324983dro_ne
droop85814823droop_
drooped11368433drooped
droops95110963droops
droopy12458243droopy
drop75324403dro_p_
dropped13329283dropped
dropper12329873dropper
drops85719503dro_ps
dropt86924433dro_pt
drouk1039433drou_k
drouked1335543drouked
drouks1137123drouks
drouth104410103drouth
drove95518063dro_ve
drowse105010553drowse
drupes94912653dr_upes
druse64817663dr_use
dupe76630603__dupe
elope75219343elo_pe
erode64520993ero_de
erose55727273ero_se
erupt74220063er_upt
frappe13286953frappe
froe75329993fro__e
frore86218803fro_re
frounce1236153frounce
frouzy21395283frouzy
froze174515653fro_ze
gouge78220063_gouge
grape84824663gr_ape
graupel1034133graupel
gripe84622963gr_ipe
grippe115310323grippe
groove10438873groove
groped107515053gro_ped
groper94517253gro_per
gropes95220403gro_pes
grosze16457733grosze
grouch12318473grouch
ground82310273ground
groupers11358633groupers
groupies1137523groupies
groused94712833groused
grouser84513693grouser
grouses84616543grouses
grout65330423grou_t
grouted94111503grouted
grouter84412523grouter
grouts75015613grouts
grouty104710983grouty
grove95219333gro_ve
groyne1037213groyne
grue55825713gr_u_e
grume86218163gr_ume
hope96639673_ho_pe
house89131423_house
irone55126363iro_ne
irrupt846993irrupt
joule124918203_joule
jupe134921003__jupe
krone94018733kro_ne
lope65941923_lo_pe
louie55023513_louie
loup66028433_loup_
louped95316383_louped
loupen84510293_loupen
loupes84918053_loupes
loups75319623_loups
louse56131013_louse
mope86838043_mo_pe
moue65835573_mou_e
mouse77133003_mouse
myope124010973myo_pe
nope65934193_no_pe
ope56845243__o_pe
ordure756803ordure
oroide7311703oroide
ouph95618373__ouph
ouphe104413263__ouphe
pope85535613_po_pe
probe94320813pro_be
procure1138573procure
produce1267513produce
profuse1237153profuse
prole74527793pro_le
prompt12313013prompt
prone75332623pro_ne
prop85932813pro_p_
propel103714063pro_pel
proper104319953pro_per
propped113311953propped
props95726883pro_ps
prose75835123pro_se
prosper114012183prosper
proud84615483prou_d
prouder10310373prouder
prove104823193pro_ve
prude84615973pr_ude
prune75119633pr_une
pyrope132810533pyro_pe
rape65041633_r_ape
recoupe11109933recoupe
reroute7313963reroute
reuse56025363_reuse
ripe66038923_r_ipe
robe65335643_ro_be
roble75223023_roble
rode55844303_ro_de
roe36861073_ro__e
rogue66417533_rogue
role45851823_ro_le
romp85926573_romp_
romped114513653_romped
romper104213683_romper
romps94617543_romps
roose56127093_roose
roped84630803_ro_ped
roper75431913_ro_per
ropes75940063_ro_pes
ropey106021873_ro_pey
ropy96323413_ro_py
roque144812133_roque
rose46148903_ro_se
rote46249023_ro_te
rotte54625933_rotte
rouble83913313_rouble
rouche114714313_rouche
rouen54920903_rouen
roues56039353_roues
rouged86717323_rouged
rouges76022383_rouges
rough97819433_rough
round64318433_round
roupier9319493_roupier
roused75426443_roused
rouser65224083_rouser
rouses65436283_rouses
roust55532063_roust
rout46153283_rou_t
routed75624333_routed
router65025843_router
routes66129313_routes
routh86423073_routh
routs57133413_routs
roux117419363_rou_x
rove75136983_ro_ve
rube65532013_r_ube
rude55632783_r_ude
rue35549263_r_u_e
rule49938423_r_ule
rune45236293_r_une
rupee7321283_r_upee
ruse45938933_r_use
scope94821483sco_pe
scouse84113633scouse
scrouge1036353scrouge
shoppe133110313shoppe
slope75823563slo_pe
soup66232913_soup_
souped95017673_souped
soups75322943_soups
soupy106115403_soupy
souse56530773_souse
spouse84112513spouse
stope74727243sto_pe
stoup75517073stoup_
stoups85313273stoups
stoure64814943stoure
stripe85822443str_ipe
strobe84513813stro_be
strode75215973stro_de
stroke105116173stro_ke
strop77422243stro_p_
strophe1239133strophe
stropped1367333stropped
stropper1247753stropper
stroppy14205093stroppy
strops86220383stro_ps
stroud7310383strou_d
strouds837793strouds
strove95014793stro_ve
stupe75217753_stupe
supe65932763__supe
tape64538143t__ape
tartufe1064673tartufe
taupes8212673t_aupes
tenure6311613tenure
thole85620843tho_le
thorp104414263thorp_
thorpes125010353thorpes
thorps113610893thorps
those85218143tho_se
thou76722213thou__
thoued10429003thoued
though139410763though
thous86017253thou_s
throe89321423thro__e
throne98517603thro_ne
through141647513through
throve128012393thro_ve
toe310166853t_o__e
togae67020113t_ogae
togue64816303t_ogue
toile54626493t_oile
toke86738493t_o_ke
tole46052903t_o_le
tome67543193t_o_me
tone46953743t_o_ne
tonne54921433t_onne
toonie63617993toonie
tootle62613813tootle
top510560683t_o_p_
toped85631313t_o_ped
topee76029953t_opee
toper75231023t_o_per
topes76941763t_o_pes
toph96326873t_o_ph
tophe106718973t_ophe
topi67830393t_o_pi
topo66932403t_o_po
topped114617723t_opped
topper103817603t_opper
topple104411323t_opple
tops66248123t_o_ps
toque145113093t_oque
tore47359323t_o_re
torose64317693torose
torous64319023torou_s
torque15237673torque
torse55833333t_orse
torte55431703t_orte
torture738593torture
torula6610393torula
torulae758553torulae
torus54329763toru_s
tote46643673t_o_te
touch106519393t_ouch
touche114916173t_ouche
tough97321983t_ough
toupees938513t_oupees
tour45530373t_ou_r
toured74216153t_oured
tourer64115073t_ourer
tours55325863t_ours
toused74122013t_oused
touses64229673t_ouses
tousle64514653t_ousle
tout46753823t_ou_t
touted74419743t_outed
touter63821033t_outer
touts54830393t_outs
touzle15429003t_ouzle
towie85821873t_owie
towrope1245583towro_pe
trace75829613tr_ace
trade65026043tr_ade
traduce1036343traduce
traipse935873traipse
tramp96319773tramp_
tramped124312433tramped
tramper113812153tramper
trample11299703trample
tramps105114453tramps
trampy13499253trampy
trance84718763trance
trap67532803tr_ap_
trapes85024463tr_apes
trapped124512213trapped
trapper113912793trapper
traps75727483tr_aps
trapt76433393tr_apt
trauma838803trauma
trave85223033tr_ave
treble8311663treble
tree47745813tr__ee
triage72812893triage
tribe74420263tr_ibe
tribune945573tribune
tribute937313tribute
trice75127493tr_ice
tricep103911073tricep
triene64316383triene
trifle94012883trifle
trike95320163tr_ike
trine54734603tr_ine
triode75311893triode
triose64715383triose
trip66830393tr_ip_
tripes85324873tr_ipes
triple84215923triple
tripped123911693tripped
tripper113711923tripper
trippet113714113trippet
trippy13457803trippy
trips74923363tr_ips
triste63818643triste
trite54730033tr_ite
triumph1453333triumph
triunes74311383triunes
troak95213573tro_ak
troaked12438253troaked
troaks104410593troaks
trocar848763trocar
trochee122613873trochee
troches123715343troches
trock114817603tro_ck
trocked144312243trocked
trocks123614633trocks
trod57627953tro__d
trodden934883trodden
troffer13125863troffer
trog57628213tro__g
trogon73611753trogon
trogs67022603tro_gs
troika1035493troika
trois57226093tro_is
troked114114583troked
trokes104019263trokes
troll54416533tro_ll
trolled84312263trolled
troller73913173troller
trolley10328753trolley
trolls64613943trolls
trolly94012353trolly
trommel11315363trommel
trona54118953tro_na
tronas63816893tronas
trones65629283trones
troopers10289423troopers
trooz145016153tro_oz
trophy1438283trophy
tropic103014193tropic
tropin83316753tropin
tropine93116653tropine
trot46351313tro__t
troth85622203tro_th
trothed114010973trothed
troths95414153troths
trots56629943tro_ts
trotted83711283trotted
trotter73312253trotter
trotyl9236673trotyl
troubled1134973troubled
troubler1035283troubler
troubles1057183troubles
troughs11698673troughs
trounced1135033trounced
trouncer1035433trouncer
trounces1037053trounces
troupial1044183troupial
trouping11249503trouping
trousers83910623trousers
troutier8277143troutier
trouvere1144053trouvere
trouveur1141663trouveur
trover95014663trover
troves94719113troves
trow78031423tro__w
trowed104714653trowed
trowel94211463trowel
trows88826183tro_ws
trowth1277883trowth
troy77429683tro__y
troys86418613tro_ys
truced95312053tr_uced
truces84916333tr_uces
truck116115463tr_uck
trudge8318733trudge
trued65117693tr_ued
truer54916643tr_uer
trues54925323tr_ues
truffe1276233truffe
trug55720043tr_u_g
trugs65516803tr_ugs
trull54012673tr_ull
truly84111553tr_uly
trump95615123tr_ump
trumped12439713trumped
trumpet113810723trumpet
trumps104611883trumps
trunk94713043tr_unk
truss54916923tr_uss
trust55426853tr_ust
truth85214153tr_uth
tryout9410753tryou_t
tryouts1035293tryouts
tryste9399583tryste
tube65828663t__ube
tubule839853tubule
tule45735873t__ule
tune45635863t__une
tup56037543t__up_
tups65628763t__ups
tuque14469193tuqu_e
turnup835093turnup_
turnups933893turnups
type96223743t__ype
uprouse937223uprouse
vrouw11507343vrou_w
vrouws12494743vrouws
wrote84717483wro_te
youse85322233_youse

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127165206.34317770.1
3Display Results5205200.1563333.3
 (SQL Overall)1786915206.64226903.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.