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

351 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
troupers1035944(None) 
groupers11358641groupers
troopers10289441troopers
trouper93811431trouper_
troupes94112851troupe_s
trousers83910631trousers
arousers84810982arousers
croppers143311482croppers
croupes114613102croupe_s
croupiers1334652croupiers
droppers13318602droppers
gropers104813852gro_pers
grouper104210092grouper_
grousers93810732grousers
grouters95910082grouters
propers113619032pro_pers
prospers123012262prospers
rompers113412242_rompers
ropers84325902_ro_pers
rousers75220142_rousers
routers74822872_routers
stroppers1356712stroppers
topers85025322t_o_pers
toppers113914602t_oppers
toupees938512t_oupees
tourers73512742t_ourers
touters74018352t_outers
trampers123210392trampers
trappers123711042trappers
trippers123210162trippers
troffers14125432troffers
trollers83211212trollers
trompes114111622trompe_s
trooper94210362trooper_
tropes84824352tro_pe_s
trotters83310242trotters
troublers1135002troublers
trouncers1134802trouncers
troupe84812432troupe__
trouped103910982troupe_d
trouser73812472trouser_
trouvere1144072trouvere
trouveres1243772trouveres
trouveurs1241642trouveurs
trovers103713322tro_vers
trowsers11428002trowsers
arguers8489033argu_ers
armourers1154063armourers
arouser74514423arouser_
arouses74921293arouse_s
bloopers12397373bloopers
boppers133911923_boppers
broiders114211193broiders
broilers103210093broilers
brokers133111913bro_kers
bronzers19296983bronzers
brooders112610243brooders
brothers133410833brothers
browsers13449203browsers
carousers1156743carousers
chompers17369593chompers
choppers174110463choppers
chousers134610203chousers
clouters10399803clouters
coopers114019483_coopers
copers104629843_co_pers
coppers133519753_coppers
corulers1039773corulers
coupes105022523_coupe_s
couplers123311323_couplers
couters93827303_couters
crappers144011023crappers
creepers12318633creepers
crimpers14318933crimpers
crispers12309433crispers
croakers14288523croakers
crofters13358903crofters
crooners103911393crooners
cropper133312963cropper_
crosiers103312063crosiers
crossers103912703crossers
croupe105114433croupe__
croupier1246883croupier_
croupous1245923croupous
croups104312553croup__s
croutes94815653croute_s
crowders14398813crowders
crowers124614903cro_wers
crowners133710753crowners
crozers184111083cro_zers
croziers19287003croziers
cruppers14317323cruppers
dopers95522483_do_pers
dorpers104113173_dorpers
dousers84817273_dousers
drapers105313353dr_apers
drippers13327943drippers
droners84114383dro_ners
dropper12329873dropper_
drovers115212643dro_vers
drowners12428273drowners
drupes94912653dr_upe_s
dupers94615603__dupers
elopers95112943elo_pers
floppers15337463floppers
flouters11419273flouters
frothers14279813frothers
frowners14377933frowners
gougers94911763_gougers
graspers11338403graspers
graupels1133103graupels
gripers104011463gr_ipers
grippers13358133grippers
groaners9248503groaners
grocers103511253gro_cers
groomers11388483groomers
groovers12337123groovers
groper94517253gro_per_
gropes95220403gro_pe_s
grossers94410973grossers
grounders1156783grounders
grouped11419193groupe_d
groupies1137523groupies
groups94210513group__s
grouser84513693grouser_
grouses84616543grouse_s
grouter84412523grouter_
growers113612723gro_wers
growlers12327093growlers
hoopers123616483_hoopers
hopers114222973_ho_pers
hoppers143115143_hoppers
housers104717813_housers
ironers74813553iro_ners
kreuzers2132063kreuzers
larrupers1142523larrupers
loopers93914033_loopers
lopers84424143_lo_pers
loppers113014103_loppers
loupes84918053_loupe_s
louvers10359103_louvers
mopers104220373_mo_pers
moppers133412463_moppers
mousers95216443_mousers
outers64230173__outers
paupers114311073_paupers
poppers103414863_poppers
pourers93513673_pourers
pouters94221873_pouters
probers113514583pro_bers
procurers1345033procurers
prodders1237463prodders
producers1454883producers
proffers16126593proffers
proggers12258163proggers
prompters1537553prompters
proofers13118363proofers
propels113412843pro_pels
proper104319953pro_per_
prosers94219643pro_sers
prosper114012193prosper_
prouder10310383prouder_
provers123817793pro_vers
prowlers13328933prowlers
pruners93710723pr_uners
rapers84327183_r_apers
rappers113618443_rappers
raspers94415923_raspers
reapers93520453_reapers
rippers114115033_rippers
roamers93713463_roamers
roarers73812743_roarers
robbers112814163_robbers
rockers133916553_rockers
rogers74517913_ro_gers
rolfers104011813_rolfers
rollers73117473_rollers
romper104213683_romper_
roofers105013903_roofers
roomers95416413_roomers
roosers74217873_roosers
rooters74522933_rooters
roper75431913_ro_per_
ropery114313873_ro_pery
ropes75940063_ro_pe_s
rosters73727543_rosters
rotters74421393_rotters
rouens64814443_rou_ens
roues56039353_rou_e_s
rouges76022383_rouge_s
roughers12329183_roughers
rounders92613693_rounders
rouped95717353_roupe_d
roupet84218343_roupe_t
roupier9319493_roupier_
roups75118903_roup__s
rouser65224083_rouser_
rouses65436283_rouse_s
rousters84315683_rousters
router65025843_router_
routes66129313_route_s
rovers95423523_ro_vers
rowers94924573_ro_wers
rozzers1535633_rozzers
ruers515019413_r_u_ers
rulers64317093_r_ulers
rupees8312573_r_upees
scaupers12378173scaupers
scoopers124210193scoopers
scourers10348533scourers
scouters103411323scouters
shoppers153010763shoppers
shouters113510623shouters
slopers94213093slo_pers
snoopers10319843snoopers
soapers93715923_soapers
souters74422603_souters
spouters104011163spouters
stompers123610043stompers
stoopers103711303stoopers
stopers94217373sto_pers
stoppers123910593stoppers
strappers1346743strappers
stripers103911593str_ipers
strippers1355773strippers
strokers123910903stro_kers
strollers937553strollers
stropper1247763stropper_
stroyers11388923stro_yers
supers84622403__supers
swoopers13317523swoopers
tabourers1144673tabourers
tampers113516743t_ampers
tapers84025813t__apers
tappers113416543t_appers
tarpapers1344273tarpapers
taupes8212673t_aupe_s
tempers113513013t_empers
thorpes125010353thorpe_s
threapers1444773threapers
throbbers1643173throbbers
throwers14106033thro_wers
thumpers15365713thumpers
tippers113414353t_ippers
tochers123413093t_ochers
toilers74116263t_oilers
tokers104818893t_o_kers
tollers73217463t_ollers
toners64128003t_o_ners
tongers84116013t_ongers
tonners73816403t_onners
toolers74416503t_oolers
tooters73818773t_ooters
tootlers8289503tootlers
topees85519703t_o_pees
toper75231023t_o_per_
topes76941763t_o_pe_s
topper103817603t_opper_
torpors939383t_orpors
torquers17204303torquers
torturers944343torturers
tossers74713503t_ossers
toters65026363t_o_ters
totters74618733t_otters
touchers133611213t_ouchers
toupee8316133t_oupe_e
tourer64115073t_ourer_
tours55325893t_ou__rs
touses64229673t_ouse_s
touter63821033t_outer_
towers94423673t_o_wers
toyers95516333t_o_yers
tracers94917843tr_acers
trackers143512853trackers
traders84316953tr_aders
traducers1243723traducers
trailers82912923trailers
trainers83114643trainers
tramper113812163tramper_
tramplers13305883tramplers
trapes85024463tr_ape_s
trapper113912803trapper_
trashers113013643trashers
trawlers113310203trawlers
treaders93311843treaders
treaters83615843treaters
trekkers1133803trekkers
trickers143812813trickers
triers64321523tr__iers
triflers113110213triflers
triggers10257843triggers
trillers83613493trillers
trimers94615143tr_imers
trimmers12288913trimmers
tripes85324873tr_ipe_s
tripper113711923tripper_
trippets12357423trippets
triunes74311383triune_s
trocars959043tro_cars
trochars1377853trochars
trochees132510183trochees
troches123715343troche_s
troffer13125863troffer_
trokes104019263tro_ke_s
troller73913173troller_
trolleys11315693trolleys
trommels12254333trommels
trompe105611263trompe__
tromped124210293trompe_d
tromps104911703tromp__s
trones65629283tro_ne_s
trooped104010723troope_d
troops85712783troop__s
trope75725803tro_pe__
tropics113610653tro_pics
tropins93116313tro_pins
trotter73312253trotter_
troubler1035293troubler_
troubles1057203troubles
troughs11698683trou_ghs
trouncer1035443trouncer_
trounces1037063trounces
troupial1044183troupial
troupials1142933troupials
trouping11249503trouping
troutier8277153troutier_
trouts66116633trou__ts
trouveur1141673trouveur
trover95014663tro_ver_
troves94719113tro_ve_s
trowelers12105263trowelers
trowels10358363tro_wels
truces84916333tr_uce_s
truckers14279013truckers
trudgers10256863trudgers
truer54916643tr_u_er_
trues54925323tr_u_e_s
trumpery1533613trumpery
trumpets12315573trumpets
trussers8348283trussers
trusters83112263trusters
trysters11298373trysters
tubers85017033t__ubers
tuners64417343t__uners
tuyers94612563t__uyers
twofers1364053two_fers
whoopers16286263whoopers
whoppers18297533whoppers
wrappers15306933wrappers
wrongers12327773wrongers
yaupers12337663_yaupers

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.420425454.8
2DLD Change Limit1461623516.55022314.8
3Display Results3513510.1402507.1
 (SQL Overall)1786913517.11025132.3
 
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.