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 “trouper” 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
trouper9381143(None) 
grouper104210091grouper
trooper94210361trooper
troupe84812431troupe_
trouped103910981trouped
troupers10359441troupers
troupes94112851troupes
trouser73812471trouser
arouser74514422arouser
cropper133312962cropper
croupe105114432croupe_
croupes114613102croupes
croupier1246882croupier
dropper12329872dropper
groper94517252gro_per
grouped11419192grouped
groupers11358642groupers
grouser84513692grouser
grouter84412522grouter
proper104319952pro_per
prosper114012192prosper
prouder10310382prouder
romper104213682_romper
roper75431912_ro_per
rouped95717352_rouped
roupet84218342_roupet
roupier9319492_roupier
rouser65224082_rouser
router65025842_router
stropper1247762stropper
toper75231022t_o_per
topper103817602t_opper
toupee8316132t_oupee
tourer64115072t_ourer
touter63821032t_outer
tramper113812162tramper
trapper113912802trapper
tripper113711922tripper
troffer13125862troffer
troller73913172troller
trompe105611262trompe_
tromped124210292tromped
trompes114111622trompes
trooped104010722trooped
troopers10289442troopers
trope75725802tro_pe_
tropes84824352tro_pes
trotter73312252trotter
troubler1035292troubler
trouncer1035442trouncer
trousers83910632trousers
troutier8277152troutier
trouvere1144072trouvere
trouveur1141672trouveur
trover95014662tro_ver
truer54916642tr_u_er
arguer74510543argu_er
armourer1054883armourer
arouse65019983arouse_
aroused84914343aroused
arousers84810983arousers
arouses74921293arouses
blooper11358533blooper
bopper123813833_bopper
broader103412613broader
broider103912973broider
broiler92911753broiler
broker124314243bro_ker
bronzer18348493bronzer
brooder103811623brooder
brother123311333brother
browner124911643browner
browser124911143browser
carouser1068843carouser
chomper163810073chomper
chopper163611893chopper
chouser125212943chouser
clouter93511693clouter
cooper104221123_cooper
coper95336093_co_per
copper124321893_copper
coruler9311713coruler
coupe96023483_coupe_
couped115019313_couped
coupes105022523_coupes
coupler114713013_coupler
couter84930223_couter
crapper133913193crapper
creeper11339983creeper
crimper136510423crimper
crisper113511053crisper
croaker133010683croaker
crofter12299573crofter
crooker134111093crooker
crooner93714043crooner
cropped143812063cropped
croppers143311483croppers
crosier94116573crosier
crosser95015463crosser
croup95616783croup__
croupiers1334653croupiers
croups104312553croup_s
croupy13458733croup_y
crouse84619363crouse_
croute84617273croute_
croutes94815653croutes
crowder13389863crowder
crower114117563cro_wer
crowner124012603crowner
crozer175112843cro_zer
crozier18369933crozier
cruder95612383cr_uder
crupper13338563crupper
doper86128393_do_per
dorper94314573_dorper
dourer74215273_dourer
douser75621633_douser
draper94315693dr_aper
dripper12349233dripper
droller84110283droller
droner74717673dro_ner
drooped11368433drooped
droopier1145573droopier
dropped13329283dropped
droppers13318603droppers
drouked1335543drouked
drover104614593dro_ver
drowner11369803drowner
drupe85012993dr_upe_
drupes94912653dr_upes
duper85519003__duper
eloper85414153elo_per
flopper14328473flopper
flouter104311343flouter
fouler93614903_fouler
fronter103611583fronter
frother133110153frother
frouzier2043703frouzier
frowner13429683frowner
gouger86014363_gouger
grasper10389793grasper
graupel1034133graupel
griper94114613gr_iper
gripper124410713gripper
groaner82510133groaner
grocer94212143gro_cer
grodier939673grodier
groomer10399873groomer
groover11358543groover
grope84821613gro_pe_
groped107515053gro_ped
gropers104813853gro_pers
gropes95220403gro_pes
grosser84313143grosser
grounder1047613grounder
group85413923group__
groupie1045783groupie
groupies1137523groupies
groups94210513group_s
grouse74315023grouse_
groused94712833groused
grousers93810733grousers
grouses84616543grouses
grouted94111503grouted
grouters95910083grouters
groutier9297173groutier
grower104614933gro_wer
growler11318973growler
hooper114518313_hooper
hoper105829143_ho_per
hopper134218483_hopper
houser95322283_houser
ironer64216453iro_ner
kreuzer2032353kreuzer
kroner104612573kro_ner
larruper1042743larruper
looper83817113_looper
loper75129233_lo_per
lopper103717203_lopper
louder74414603_louder
loupe75319513_loupe_
louped95316383_louped
loupen84510293_loupen
loupes84918053_loupes
louver94110393_louver
moper94925923_mo_per
mopper126215003_mopper
mouser85822443_mouser
outer55633303__outer
pauper103511943_pauper
popper93615963_popper
pourer84516043_pourer
pouter83923983_pouter
prober104516073pro_ber
procurer1235833procurer
prodder1147953prodder
producer1355843producer
proffer15126933proffer
progger11319373progger
prompter1437983prompter
proofer12149103proofer
propel103714063pro_pel
propers113619033pro_pers
propped113311953propped
proser84223463pro_ser
prosier93817483prosier
prospers123012263prospers
prover113819723pro_ver
prower114218123pro_wer
prowler123310013prowler
pruner83413453pr_uner
raper74932753_r_aper
rapper104621573_rapper
rasper83917333_rasper
reaper84223143_reaper
riper74328403_r_iper
ripper103518653_ripper
roamer84715163_roamer
roarer63914333_roarer
robber103916533_robber
rocker124319573_rocker
roger64521413_ro_ger
rolfer94412273_rolfer
roller63919793_roller
romped114513653_romped
rompers113412243_rompers
roofer94415283_roofer
roomer84718633_roomer
rooser63921883_rooser
rooter64926033_rooter
rope65542913_ro_pe_
roped84630803_ro_ped
ropers84325903_ro_pers
ropery114313873_ro_pery
ropes75940063_ro_pes
ropey106021873_ro_pey
ropier84118803_ropier
rosier64221263_rosier
roster64329083_roster
rotter64325463_rotter
roue45941743_rou_e_
rouen54920903_rou_en
roues56039353_rou_es
rouge65423443_rouge_
rouged86717323_rouged
rouges76022383_rouges
rougher113511033_rougher
rounder83514603_rounder
roup66627693_roup__
roups75118903_roup_s
roupy106112713_roup_y
rouse56634703_rouse_
roused75426443_roused
rousers75220143_rousers
rouses65436283_rouses
rouster73517083_rouster
route55132073_route_
routed75624333_routed
routers74822873_routers
routes66129313_routes
rover85527373_ro_ver
rower85430493_ro_wer
rozzer1437353_rozzer
ruder65320543_r_uder
ruer46127563_r_u_er
ruler54923343_r_uler
rupee7321283_r_upee
scauper11379453scauper
scooper113812033scooper
scourer93910433scourer
scouter93313323scouter
shopper143312633shopper
shouter103213083shouter
sloper84615913slo_per
snooper93511533snooper
soaper84517873_soaper
souped95017673_souped
soupier93111753_soupier
sourer63620213_sourer
souter64225923_souter
spouter94213223spouter
stomper114111233stomper
stooper93813193stooper
stoper84320103sto_per
stopper113012603stopper
stouter74012053stouter
strapper1258093strapper
striper94514793str_iper
stripper1247123stripper
stroker114113523stro_ker
stroller848173stroller
stronger9349693stronger
stropped1367343stropped
stroppers1356713stroppers
stroppier1364453stroppier
stroyer103510783stro_yer
super74924483__super
swooper12389173swooper
tabourer1035743tabourer
tamper104618513t_amper
taper74829773t__aper
tapper104419613t_apper
tarpaper1244603tarpaper
taupe7314163t_aupe_
taupes8212673t_aupes
tauter64318023t_auter
temper103914093t_emper
thorpe113610093thorpe_
thorpes125010353thorpes
thoued10429003thou_ed
threaper1345143threaper
throbber1543203throbber
thrower1386993thro_wer
thumper14356953thumper
tipper103918413t_ipper
tocher114014913t_ocher
toiler63918283t_oiler
toker95924913t_o_ker
toller63819443t_oller
toner55336243t_o_ner
tonger74719683t_onger
tonier65520713t_onier
tonner64819203t_onner
tooler63818613t_ooler
tooter64420803t_ooter
tootler73511123tootler
tope65946383t_o_pe_
toped85631313t_o_ped
topee76029953t_o_pee
topers85025323t_o_pers
topes76941763t_o_pes
topped114617723t_opped
toppers113914603t_oppers
torpor839193t_orpor
torquer16205323torquer
torturer835493torturer
tosser64215663t_osser
toter55932133t_o_ter
tother94117143t_other
totter65021463t_otter
toucher124814353t_oucher
tougher114210983t_ougher
toupees938513t_oupees
tour45530383t_ou__r
toured74216153t_oured
tourers73512743t_ourers
touse55430673t_ouse_
toused74122013t_oused
touses64229673t_ouses
touted74419743t_outed
touters74018353t_outers
tower85729203t_o_wer
toyer84521553t_o_yer
tracer84820233tr_acer
tracker133515173tracker
trader75218763tr_ader
traducer1144583traducer
trailer73015393trailer
trainer73316793trainer
tramped124312433tramped
trampers123210393trampers
trampier12318243trampier
trampler12278013trampler
trapes85024463tr_apes
trapped124512213trapped
trappers123711043trappers
trasher104416133trasher
trawler104011903trawler
treader84113833treader
treater74219833treater
trekker1034733trekker
tricker134615523tricker
trier54328533tr__ier
trifler103912153trifler
trigger9329163trigger
triller74215893triller
trimer85717153tr_imer
trimmer113610833trimmer
tripe75425383tr_ipe_
tripes85324873tr_ipes
tripped123911693tripped
trippers123210163trippers
trippet113714113trippet
trippier1246623trippier
triter65120593tr_iter
triune64210183triune_
triunes74311383triunes
troaked12438253troaked
trocar848773tro_car
trochar1257073trochar
troche113112513troche_
trochee122613883trochee
troches123715343troches
trocked144312243trocked
trodden934883trodden
trode65322853tro_de_
troffers14125433troffers
troke94821053tro_ke_
troked114114583tro_ked
trokes104019263tro_kes
trolled84312263trolled
trollers83211213trollers
trolley10328753trolley
trommel11315363trommel
tromp95815803tromp__
tromps104911703tromp_s
trone55131863tro_ne_
trones65629283tro_nes
troop76417533troop__
troops85712783troop_s
trop66833303tro_p__
trophy1438283tro_phy
tropic103014193tro_pic
tropin83316753tro_pin
trothed114010973trothed
trotted83711283trotted
trotters83310243trotters
trouble957713trouble
troubled1134983troubled
troublers1135003troublers
troubles1057203troubles
trough108512023trou_gh
troughs11698683troughs
trounce936823trounce
trounced1135033trounced
trouncers1134803trouncers
trounces1037063trounces
troupial1044183troupial
trouping11249503trouping
trout57332573trou__t
trouts66116633trou_ts
trouty95211793trou_ty
trouveres1243773trouveres
trouveurs1241643trouveurs
trove85221923tro_ve_
trovers103713323tro_vers
troves94719113tro_ves
trowed104714653tro_wed
trowel94211463tro_wel
troweler11106063troweler
trowsers11428003trowsers
truce75118693tr_uce_
truced95312053tr_uced
truces84916333tr_uces
trucker134010733trucker
trudger9338733trudger
true46725853tr_u_e_
trued65117693tr_u_ed
trues54925323tr_u_es
trumped12439713trumped
trumpery1533613trumpery
trumpet113810723trumpet
trusser74010263trusser
truster73114313truster
tryster10369513tryster
tuber75420683t__uber
tuner56022683t__uner
tuyer85414293t__uyer
twofer1234353two_fer
whooper15297153whooper
whopper17328503whopper
wrapper14368333wrapper
wronger11288823wronger
yauper11368543_yauper

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274648.03016690.8
3Display Results4644640.1562974.4
 (SQL Overall)1786914648.59220797.4
 
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.